MSSQL 특정 단어가 포함된 프로시저 찾기

How can I find stored procedure by search text in MS-SQL

SELECT ROUTINE_NAME
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_DEFINITION LIKE '%Search_Text%'
AND ROUTINE_TYPE='PROCEDURE'
order by ROUTINE_NAME

추가: varchar(4000) 보다 큰 sp까지 찾는 방법

SELECT so.name FROM dbo.sysobjects so,dbo.syscomments sc
WHERE so.id=sc.id AND type = 'P' 

AND sc.text LIKE '%Search_Text%' ORDER BY so.name