>>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.
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com