Advanced Search

Return to Snippet

Revision: 32276
at September 22, 2010 00:08 by samwa
Initial Code 
DECLARE @StringToSearch varchar(100) 

SET @StringToSearch = 'searchstring'

SET @StringToSearch = '%' +@StringToSearch + '%'
   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 @stringtosearch
   ORDER BY SO.Name
Initial URL 
http://www.knowdotnet.com/articles/storedprocfinds.html
Initial Description 

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
Search stored procedures

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    
sql

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
SQL