Skip to content

Instantly share code, notes, and snippets.

@mikaelweave

mikaelweave/scan_sprocs

Created December 5, 2017 22:01
Show Gist options
  • Save mikaelweave/7a0f71c593c6ccecae0e967c83397df4 to your computer and use it in GitHub Desktop.
Save mikaelweave/7a0f71c593c6ccecae0e967c83397df4 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
scan_sprocs
SELECT DISTINCT
o.name AS Object_Name,
o.type_desc
FROM sys.sql_modules m
INNER JOIN
sys.objects o
ON m.object_id = o.object_id
WHERE m.definition Like '%ABD%';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment