>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.
Hello!
I think this is what you want:
http://sqldev.wordpress.com/2008/04/06/which-of-your-stored-procedures-are-no-longer-valid/I used something similar to see which one should be cleaned out
-R!
Ricardo A. Parodi
eSolar, Inc.