Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 finding text stored procedures

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2002-03-31 : 22:38:30
victoria writes "hi,
i want to search all of my stored procs for a keyword.
i have not been able to find out how to do this.
is it possible?"

nr
SQLTeam MVY

12543 Posts

Posted - 2002-03-31 : 23:38:47
You can look through syscomments.
or
script all the SPs and search the files.

This is no problem if you keep the SPs in sourcesafe.

==========================================
Cursors are useful if you don't know sql.
Beer is not cold and it isn't fizzy.
Go to Top of Page
   

- Advertisement -