-- SP 에서 내용 찾기
SELECT A.name
, B.text
FROM dbo.sysobjects AS A
INNER JOIN dbo.syscomments AS B ON A.id = B.id
WHERE A.xtype = 'P' -- SP
AND A.category = '0'
AND B.text LIKE '%내용%'
-- SP 에서 내용 찾기
SELECT A.name
, B.text
FROM dbo.sysobjects AS A
INNER JOIN dbo.syscomments AS B ON A.id = B.id
WHERE A.xtype = 'P' -- SP
AND A.category = '0'
AND B.text LIKE '%내용%'