andyfrench.info

To find a Stored Procedure containing specific text run the following SQL:

SELECT OBJECT_NAME(object_id) 
FROM sys.sql_modules 
WHERE
definition LIKE '%[text to search for here]%' AND
OBJECTPROPERTY(object_id, 'IsProcedure') = 1 
ORDER BY 1