>>>>If you are talking about the answer provided, it is returning the list of valid schemas and objects used by the query. That doesn't tell me if there are some that are not recognized.
>>>
>>>Check this blog http://facility9.com/2009/02/16/automating-t-sql-testing
>>
>>I finally found something. Check http://www.codeproject.com/KB/database/validate-sqlserver-proc.aspx
>>
>>It is a C# application that does it (with the Set NoExec On).
>>
>>I would prefer a pure T-SQL query. If anybody can comes with something.
>
>Nice, but it would not catch changes in the table structure. I just discussed this option in LTD http://forum.lessthandot.com/viewtopic.php?f=17&t=9480&p=47207

Yes it does, it returns error that columns are not existing anymore.