SELECT ROUTINE_NAME 
     FROM INFORMATION_SCHEMA.ROUTINES
     WHERE ROUTINE_DEFINITION LIKE '%Search_Text%'
        AND ROUTINE_TYPE='PROCEDURE'
     order by ROUTINE_NAME
 

Comment +0