Click here to Skip to main content
15,891,184 members

Article Recommendation

Your Name:*
Your Email:*
Your friend's Email:*
The Message text:

Hi!,

This email was created by [MemberName] <[MemberEmail]> who thought you would be interested in the following Article:

"Find all Stored Procedures having a given text in it"
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!

CodeProject also contains hundreds of articles, free source code samples and applications to help in your day to day programming. Why not give it a try!

 
Note: the details entered on this page will not be stored or used for any purpose other than for sending this email.