SQL: Find text in all Stored procedures

SELECT OBJECT_NAME(object_id), Definition FROM sys.sql_modules WHERE OBJECTPROPERTY(object_id, 'IsProcedure') = 1 AND definition LIKE '%foo%'
Find specific text in all stored procedures in the databaes

Be the first to comment

You can use [html][/html], [css][/css], [php][/php] and more to embed the code. Urls are automatically hyperlinked. Line breaks and paragraphs are automatically generated.