how to find stored procedure contain a string text?

SELECT ROUTINE_NAME, ROUTINE_DEFINITION
    FROM INFORMATION_SCHEMA.ROUTINES 
    WHERE ROUTINE_DEFINITION LIKE '%change_user%' 
    AND ROUTINE_TYPE='PROCEDURE'

Leave a Reply

Your email address will not be published. Required fields are marked *