Search All Stored Procedures

SELECT DISTINCT o.name AS Object_Name,o.type_desc

FROM sys.sql_modules m

INNER JOIN sys.objects o

ON m.object_id=o.object_id

WHERE m.definition Like '%InsertIds%'

--or

SELECT Name

FROM sys.procedures

WHERE OBJECT_DEFINITION(OBJECT_ID) LIKE '%InsertIds%'

GO

Stack Overflow

Pinal Dave