–특정 단어가 들어간 sp or table 찾기 1
SELECT ROUTINE_NAME
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_DEFINITION LIKE '%999%'
AND ROUTINE_TYPE='PROCEDURE’
order by ROUTINE_NAME
–특정 단어가 들어간 sp or table 찾기 2
SELECT B.NAME FROM syscomments A INNER JOIN sysobjects B ON A.id = B.id
WHERE B.xtype='p’
AND A.text LIKE ‘%검색어%’
