Monday, July 14, 2008

SQL Tips: Search String In All SP's


This is nice one; courtesy of our great DBA - Kostya Fridman:

SELECT name, OBJECT_DEFINITION(object_id)
FROM sys.procedures
WHERE OBJECT_DEFINITION(object_id) LIKE '%Search String%'
Posted by at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)