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 |
|
hismightiness
Posting Yak Master
164 Posts |
 Posted - 2008-07-28 : 14:51:34
|
| I know that there is a place that allows you to look at the text of Stored Procedures. However, I have two problems I need to solve. First, where is the Stored Procedure text stored?Second, how do I query that location to let me find specific Stored Procedures? For instance, maybe I want to find all Stored Procedures that have a specific table name in them. How can this be accomplished?- - - -- Will -- - - -http://www.strohlsitedesign.comhttp://blog.strohlsitedesign.com/http://skins.strohlsitedesign.com/ |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
cat_jesus
Aged Yak Warrior
547 Posts |
Posted - 2008-07-28 : 15:09:37
|
| If you want to look in just the stored procedures in a particular DB I usually runselect * from information_schema.routines where routine_definition like '%string I am looking for%'But the SP that Tara linked to is pretty nice.Thanks Tara.An infinite universe is the ultimate cartesian product. |
 |
|
|
hismightiness
Posting Yak Master
164 Posts |
|
|
|
|
|
Querying/Finding Stored Procedures