Skip to content

Instantly share code, notes, and snippets.

@mataprasad

mataprasad/search text in all object in db.sql

Created July 31, 2018 08:05
Show Gist options
  • Save mataprasad/6da42d666bd7051cd40a0780c8d31e23 to your computer and use it in GitHub Desktop.
Save mataprasad/6da42d666bd7051cd40a0780c8d31e23 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
search text in all object in db.sql
SELECT OBJECT_NAME(object_id),
OBJECT_DEFINITION(object_id)
FROM sys.procedures
WHERE OBJECT_DEFINITION(object_id) LIKE '%JV R%'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment