SQLSERVER 全局搜索SP中关键字

一、
SELECT  name
FROM    sysobjects o ,
        syscomments s
WHERE   o.id = s.id
        AND text LIKE '%需要查询的关键字%'
        AND o.xtype = 'P'

二、
SELECT name,
       type_desc
FROM   sys.all_sql_modules s
       INNER JOIN sys.all_objects o ON s.object_id = o.object_id
WHERE  definition LIKE N'%GLP%'
ORDER BY type_desc, name;