Find a string in all Stored Procedures:
SELECT OBJECT_NAME(id)
FROM syscomments
WHERE [text] LIKE '%foobar%'
AND OBJECTPROPERTY(id, 'IsProcedure') = 1
GROUP BY OBJECT_NAME(id)
Showing posts with label TSQL. Show all posts
Showing posts with label TSQL. Show all posts
Monday, June 20, 2011
Subscribe to:
Posts (Atom)