특정 문자열이 포함된 저장 프로시저 찾기

SELECT * FROM sysobjects WHERE id IN ( SELECT id FROM syscomments WHERE text LIKE '%CharterBaseID%' )

or


    SELECT DISTINCT so.name , replace(replace(replace(replace(sc.TEXT,CHAR(9), ''),CHAR(13),''),CHAR(10),''),CHAR(32),'') , so.xtype
    FROM syscomments sc
        INNER JOIN sysobjects so ON sc.id=so.id
    WHERE sc.TEXT LIKE '%키워드%'