To get List of database objects changed for last 30 days from currect date.
SELECT type, name,create_date,modify_date
FROM sys.objects
WHERE modify_date >= DATEADD(DAY, -30, GETDATE())
order by [TYPE] asc
SELECT type, name,create_date,modify_date
FROM sys.objects
WHERE modify_date >= DATEADD(DAY, -30, GETDATE())
order by [TYPE] asc
No comments:
Post a Comment