>>>>>Question: Hi
>>>>>
>>>>>I want to create a stored procs that will validate all the stored procs and the Functions (and maybe views) to ensure they are still valid. I need to return the result of this validation in a resultset.
>>>>>
>>>>>How can I loop through those objects, check the validity of the syntax and retrieve the result?
>>>>>
>>>>>An example of what I want to catch is if a table have one of its column removed, I want to find all the Stored Procs that will fail. Please don't tell me to use the "Check Dependency" button as I need to do it in batch.
>>>>
>>>>Check this thread on MSDN http://social.msdn.microsoft.com/Forums/en-US/transactsql/thread/7eec668a-969e-4fcc-ad49-bbe2a02519cf - I think it will stir you in the right direction.
>>>
>>>
>>>Thanks for your answer but that doesn't help me. It analyze the a query but my SPs are not simple queries.
>>
>>I understand, but can you pass SP code there?
>
>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