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.
| Author |
Topic |
|
mondo3
Starting Member
13 Posts |
 Posted - 2004-10-18 : 12:21:48
|
| Is there a way to search through all stored procedures for some text? or is there a way to convert all stored procedures to a txt file? thanks |
|
|
dgaylor
Yak Posting Veteran
54 Posts |
Posted - 2004-10-18 : 12:45:46
|
| select * from syscomments where text like '%'you can go under all tasks / generate script, and choose to export the stored procedures to a text file. |
 |
|
|
mondo3
Starting Member
13 Posts |
Posted - 2004-10-18 : 14:58:37
|
| that's exactly what i was looking for...thanks! |
|
|
|
X002548
Not Just a Number
15586 Posts |
|
|
|
|
|
Searching through stored procedures