Searching text in Stored Procedure | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Searching text in Stored Procedure

Hi, I was wondering if I can search for specific text in my stored procedures. Example: Say I have 100 stored procedures in my MS SQL 2005.
I want to search for a specific text in these store procedures. I don’t want to open each one and look for it. That would meant I will have to open 100 store procedure and look. Please help. Thank you. Boy
Luis Martin
Moderator All in Love is Fair
Stevie Wonder
All postings are provided “AS IS” with no warranties for accuracy.
Thank you so very much. And great thanks to the author who code it.