—-Option 1
SELECT DISTINCT so.name
FROM syscomments sc
INNER JOIN sysobjects so ON sc.id=so.id
WHERE LOWER(sc.TEXT) LIKE ‘%name%’
—-Option 2
SELECT DISTINCT o.name, o.xtype
FROM syscomments sc
INNER JOIN sysobjects o ON sc.id=o.id
WHERE LOWER(sc.TEXT) LIKE ‘%name%’
Tag: Stored Procedures
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)