Skip to content

Instantly share code, notes, and snippets.

@olivergeorge

olivergeorge/mssql-modified.md

Last active July 30, 2019 00:13
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 olivergeorge/f9231a5f6b228ac97b5c654f841c252f to your computer and use it in GitHub Desktop.
Save olivergeorge/f9231a5f6b228ac97b5c654f841c252f to your computer and use it in GitHub Desktop.
Download ZIP
What's been modified on our Microsoft SQL Server database?
Raw
mssql-modified.md

Used to check that stored procedures had been compiled after adding some indexes.

select top 10000
       name as 'Name',
       type_desc as 'Type',
       modify_date as 'Modified',
       create_date as 'Created'

from sys.all_objects
where (type = 'P' or type = 'U' or type = 'V') and is_ms_shipped = 0
order by modify_date desc

GO
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment