SQL statement to search inside stored procedure

Useful script for searching in stored procedures.

SELECT OBJECT_NAME(id)FROM syscommentsWHERE [text] LIKE ‘%searchtext%’AND OBJECTPROPERTY(id, ‘IsProcedure’) = 1GROUP BY OBJECT_NAME(id)