Search String in Stored Procedure(how to Find stored procedure contains text)

SELECT OBJECT_NAME(id) ]

    FROM SYSCOMMENTS 

    WHERE [text] LIKE '%Please%' 
    AND OBJECTPROPERTY(id, 'IsProcedure') = 1 
    GROUP BY OBJECT_NAME(id)

• Tweet
• Share
• Share
• Share
• Share

Sign up here with your email