특정단어가 사용된 SP 검색하기

SELECT DISTINCT O.NAME FROM DBO.SYSOBJECTS O JOIN DBO.SYSCOMMENTS C ON O.ID = C.ID WHERE O.XTYPE = 'P' AND C.TEXT LIKE '%검색문자열%'