Script To Search Text In SP

来源:互联网 发布:张三丰与王重阳知乎 编辑:程序博客网 时间:2024/06/08 09:15
SELECT 'sp_helptext ''' +  +s.name+'.'+ p.Name + ''''   As Stored_Procedure
        , p.modify_date
FROM sys.procedures p
Inner Join sys.schemas s On p.[schema_id] = s.[schema_id]
WHERE OBJECT_DEFINITION(OBJECT_ID) LIKE '%keyword%'
Order By p.modify_date desc
0 0