[SQLServer] 특정 단어가 포함된 프로시저 검색

SELECT ROUTINE_NAME 

FROM INFORMATION_SCHEMA.ROUTINES

WHERE ROUTINE_DEFINITION LIKE '%Search_Text%'

    AND ROUTINE_TYPE='PROCEDURE'

ORDER BY ROUTINE_NAME

출처 : http://smlim.tistory.com/190

SELECT DISTINCT o.name as Object_Name,

       o.type_desc 

FROM sys.sql_modules m 

    INNER JOIN sys.objects o 

        ON m.object_id=o.object_id 

 WHERE m.definition Like '%pop_up_work_order_pt_green_tag%'  

출처 : https://stackoverflow.com/questions/2454537/where-does-sql-server-store-the-stored-procedure-code