Search all stored procedures that contain some text
select specific_name , Routine_Definition from INFORMATION_SCHEMA.ROUTINES
where Routine_Definition like ‘%tblRatingSectionItemAttribute%’
– runs into a limit on string length
THIS WORKED
SELECT OBJECT_NAME(id) , [text]
FROM syscomments
WHERE [text] LIKE ‘%Back Flow%’
AND OBJECTPROPERTY(id, ‘IsProcedure’) = 1
GROUP BY OBJECT_NAME(id) , [text]
