Advanced Search

Return to Snippet

Revision: 13366
at April 21, 2009 13:55 by hobeau
Initial Code 
SELECT ROUTINE_NAME, ROUTINE_DEFINITION 
    FROM INFORMATION_SCHEMA.ROUTINES 
    WHERE ROUTINE_DEFINITION LIKE '%foobar%' 
    AND ROUTINE_TYPE='PROCEDURE'
Initial URL 
http://databases.aspfaq.com/database/how-do-i-find-a-stored-procedure-containing-text.html
Initial Description 
search for text in your stored procedure
Initial Title 
Search through stored procs
Initial Tags 

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
SQL