Code What I Like
Monday 5 July 2010
SQLServer - Search all stored procedures for a string
I find this a very useful little search tool
SELECT Name
FROM sys.procedures
WHERE OBJECT_DEFINITION(OBJECT_ID) LIKE '%SearchString%'
No comments:
Post a Comment
Newer Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment