Hi Folks,

Is there anyway to get get a result set of all the user store procedures in a database containing a key word. We have hundreds of store procedures in one of my production database and currently i'm scripting all of these store procedures and using ultra edit to find these words. The problem is it's such a pain having to scroll through the scripts to find a key word and then have to scroll back up to see which store procedure it is from. There's got to be an easier way to handle this. Please Advise....thank you!

Kaze



---------------------------------
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
MS Sql Server LazyDBA home page