Skip to content

Instantly share code, notes, and snippets.

@MarioBinder

MarioBinder/gist:8aaa4c95c7b0d64a2503ae7d3a30748c

Last active September 16, 2019 05:21
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save MarioBinder/8aaa4c95c7b0d64a2503ae7d3a30748c to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save MarioBinder/8aaa4c95c7b0d64a2503ae7d3a30748c to your computer and use it in GitHub Desktop.
Download ZIP
select last change date of procedures
Raw
gistfile1.sql
--select last change date of procedures.
SELECT name, create_date, modify_date
FROM sys.objects
WHERE type = 'P'
ORDER BY modify_date DESC
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment