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" <hqureshi1103@rogers.com> wrote in message
news:9715caf7.0311170627.3e888dc@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