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%'