How to search for a table name in all your stored procedures

[AdSense-A]
This quick and dirty query can search for a table name in all your stored procedures within a database. There is really nothing special about the query and I am sure most database administrators will know how to do this. It is really just for my own reference and anyone who else may need something like it.

The query itself isn’t all that special, you are, instead of using the query to search data you are searching the stored procedures themselves. Which is a neat little trick, that any programmer should know how to do. I am a firm believer that the more tricks like this that you know, or at least know where to find them, the better a programmer you will be.

 

 

Leave a Reply

Your email address will not be published. Required fields are marked *

Enter Captcha Here : *

Reload Image

This site uses Akismet to reduce spam. Learn how your comment data is processed.