Find any Text in any Stored Procedure
Please read our Disclaimer Works With-Microsoft SQL Server 2016 (RTM) – 13.0.1601.5 (X64)-Microsoft SQL Server 2014 (SP3-GDR) (KB4532095) – 12.0.6118.4 (X64) In case you need to find a certain text, a word or a string in your stored procedure assemblage, the following command will come in handy. Command: SELECT routine_name, routine_definition FROM INFORMATION_SCHEMA.ROUTINES WHERE routine_definition LIKE ‘%<replace with your text>%’