Below is the Query to achieve this:
- SELECT * FROM sys.objects
- WHERE TYPE = 'P'
- AND
- DATEDIFF(D, modify_date, GETDATE()) < 5
Join the conversation! Your thoughts help the community grow.
Sign in to leave a comment
It is the same account you read, post and publish with — and you will come straight back to this page.
Gowtham RajamanickamPosted Mar 13, 2015, 2:06 AM
Good one...