Validate many SQL statements for correctness
There's the table sys.sysdepends which will help with your stored objects.

For embedded SQL you could SET ROWCOUNT for the batch.  This will terminate the query after compilation (and hence name resolution and object binding) but before large quantities of data are processed.