Find all Stored Procedures having a given text in it

Jaume Pascual

5.00/5 (2 votes)

Oct 25, 2011

CPOL

8640

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!