[MSSQL] 특정문자열 포함된 프로시저 찾기

-- 프로시저 내용에 특정문자열 포함된 프로시저 찾기

-- 방법1:

select O.name, c.text from sys.sysobjects O join sys.syscomments C on O.id = C.id where O.xtype = 'P' and C.text like '%특정문자열%' order by name

-- 방법2:

SELECT ROUTINE_NAME FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_DEFINITION LIKE '%특정문자열%' AND ROUTINE_TYPE='PROCEDURE' order by ROUTINE_NAME