Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Find a String in a Stored Procedure
Message
General information
Forum:
Microsoft SQL Server
Category:
Stored procedures, Triggers, UDFs
Miscellaneous
Thread ID:
00433171
Message ID:
00433279
Views:
22
Very good Michael,
Do you mind if I add this in my list of sp tool?

>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
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform