Sunday 27 September 2015

Script for Recent changes in SQL Server

SELECT
    SO.Name
    ,SS.name
    ,SO.type_desc
    ,SO.create_date
    ,SO.modify_date
 FROM sys.objects AS SO
INNER JOIN sys.schemas AS SS
    ON SS.schema_id = SO.schema_id
WHERE DATEDIFF(D,modify_date, GETDATE()) < 10
AND TYPE IN ('P','U')

No comments:

Post a Comment