Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SP to search through existing objects?
Message
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Miscellaneous
Thread ID:
00687725
Message ID:
00688097
Views:
21
Thanks. Only a little over a hundred to look at. I know that too many are now commented out but it's a start.

__Stephen

>The text of all stored procedure, triggers, constraints, and rules are stored in the SYSCOMMENTS table. You can search its Text column for the phrase that you're interested in.
>
>SELECT OBJECT_NAME(id) FROM syscomments WHERE text LIKE '%authors%'
>
>-Mike
Previous
Reply
Map
View

Click here to load this message in the networking platform