Skip to content

Instantly share code, notes, and snippets.

@marcelodeandrade

marcelodeandrade/searchInProcedures.sql

Last active November 14, 2018 18:03
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save marcelodeandrade/f576611bf8acce6511097bde6a10dc8b to your computer and use it in GitHub Desktop.
Save marcelodeandrade/f576611bf8acce6511097bde6a10dc8b to your computer and use it in GitHub Desktop.
Download ZIP
Search a text in procedure definition
Raw
searchInProcedures.sql
SELECT name
FROM sys.procedures
WHERE Object_definition(object_id) LIKE '%search%'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment