Thursday, October 29, 2015

SQL SERVER Objects modified in last one month


SELECT * FROM sys.objects
WHERE TYPE = 'U' AND DATEDIFF(D,modify_date, GETDATE()) < 30

SELECT * FROM sys.objects
WHERE TYPE = 'P' AND DATEDIFF(D,modify_date, GETDATE()) < 30

SELECT * FROM sys.objects
WHERE TYPE = 'F' AND DATEDIFF(D,modify_date, GETDATE()) < 30

SELECT * FROM sys.objects
WHERE TYPE = 'V' AND DATEDIFF(D,modify_date, GETDATE()) < 30