I am looking for a SQL query validator (free or paid) for SQL Server/SQL Management Studio. Basically I am looking for a tool that makes sure that all referenced objects (tables (both actual and temp), columns, functions, sprocs, user defined types, etc.) in every sproc/function/etc. exist in the database.
We have been wasting a lot of time lately due to people removing/changing the spelling of objects and we don't find out about it for a while. Is there a tool that you all know of that I could run on a database/or at least a script and validate it against an existing database to verify the above things? I need the tool to work on MS SQL Server '08R2 or higher