Searching the Text of Stored Procedures in SQL Server

–How To Search The Text of Stored Procedures in SQL Server:

SELECT OBJECT_NAME(id)

FROM syscomments

WHERE [text] LIKE ‘%dog%’

AND OBJECTPROPERTY(id, ‘IsProcedure’) = 1

GROUP BY OBJECT_NAME(id)