Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Find a String in a Stored Procedure
Message
From
23/10/2000 17:24:10
Michael Levy
Cincinnati, Ohio, United States
 
General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Title:
Re: Find a String in a Stored Procedure
Miscellaneous
Thread ID:
00433171
Message ID:
00433215
Views:
13
The text of all stored procedures is store in the syscomments table. You can search for a specific string with a query like this:

SELECT OBJECT_NAME(id)
FROM syscomments
WHERE text LIKE '%search_string%'

-Mike
Michael Levy
MCSD, MCDBA
ma_levy@hotmail.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform