[MSSQL]특정 테이블이나 구문이 들어간 프로시저 찾는 방법

          SELECT DISTINCT B.NAME

              FROM SYS.SYSCOMMENTS A

LEFT OUTER JOIN SYS.OBJECTS B

                   ON A.ID= B.OBJECT_ID

          WHERE A.TEXT LIKE  '%'+''+'%'

 

혹은

 

SELECT ROUTINE_NAME 
        FROM INFORMATION_SCHEMA.ROUTINES
    WHERE ROUTINE_DEFINITION LIKE '%찾을 문자%'
        AND ROUTINE_TYPE='PROCEDURE'
        order by ROUTINE_NAME