Posted By

lance on 08/05/10

Tagged

Versions (?)

Last Edited at 08/05/10 05:31am

Statistics

Viewed 970 times

Favorited by 2 user(s)

Related snippets

Find Stored Procedures with specified name or contains specified text

/ Published in: SQL

Expand | Embed | Plain Text

Copy this code and paste it in your HTML

--needs to be run in the database that you want to search in
--get all procedures with name like
   SELECT DISTINCT SO.Name
   FROM sysobjects SO (NOLOCK)
   WHERE SO.Type = 'P'
   AND SO.Name LIKE '%report%'
   ORDER BY SO.Name
 
 
--get all procedures containing text like
   SELECT DISTINCT SO.Name
   FROM sysobjects SO (NOLOCK)
   INNER JOIN syscomments SC (NOLOCK) ON SO.Id = SC.ID
   AND SO.Type = 'P'
   AND SC.Text LIKE '%report%'
   ORDER BY SO.Name