Advanced Search

Return to Snippet

Revision: 29920
at August 5, 2010 05:31 by lance
Initial Code 
--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
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
Find Stored Procedures with specified name or contains specified text

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    
sql, search

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
SQL