Tag: Stored Procedures

—-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%’

–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)