Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
MS SQL Server: find text in a stored procedure
-- Second answer from here: https://stackoverflow.com/questions/14704105/search-text-in-stored-procedure-in-sql-server
SELECT
name,
SCHEMA_NAME(schema_id) AS [schema]
FROM
sys.procedures
WHERE
OBJECT_DEFINITION(object_id) LIKE '%whatever text you are looking for%';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.