SELECT Name
FROM
sys.procedures
WHERE
OBJECT_DEFINITION(OBJECT_ID)
LIKE
‘%StringYouAreSearchingFor%’
SELECT Name
FROM
sys.procedures
WHERE
OBJECT_DEFINITION(OBJECT_ID)
LIKE
‘%StringYouAreSearchingFor%’