Someone else may have a better suggestion, but this is what I do...
Right click on Stored Procedures in you database, in the Enterprise Manager.
Choose "All Tasks"
Choose "Generate SQL Scripts"
Pick all of your stored procedures, save them to a file, open the file and
use the text editors search features.
--
Jerry Boone
Analytical Technologies, Inc.
http://www.antech.biz
"Adnan Jamil" <hq**********@rogers.com> wrote in message
news:97*************************@posting.google.co m...
Hi Guys,
I want to find any specific text in all SQL server stored procedure.
How can I do this. Please let me know
Thanks in Advance