Find all Stored Procedures having a given text in it

Jaume Pascual

5.00/5 (2 votes)

Oct 25, 2011

CPOL

8391

SELECT DISTINCT so.name FROM dbo.sysobjects so inner join .dbo.syscomments sc on so.id=sc.id WHERE so.xtype='P' AND sc.text like '%SearchString%'Much faster!

SELECT DISTINCT so.name 
FROM dbo.sysobjects so 
		inner join .dbo.syscomments sc on so.id=sc.id 
WHERE so.xtype='P' AND sc.text like '%SearchString%'