[MS-SQL] DB 변경 시간 확인하기

MS-SQL에서 DB 변경 시간 확인하기

SELECT TE.name, T.StartTime, T.DatabaseName, T.ObjectName, T.NTUserName, T.NTDomainName, T.LoginName, T.HostName, T.ApplicationName
FROM sys.fn_trace_gettable(
    (SELECT REVERSE(SUBSTRING(REVERSE(path), CHARINDEX('\', REVERSE(path)), 256)) + 'log.trc' FROM sys.traces WHERE is_default = 1), default) as T
INNER JOIN sys.trace_events as TE on T.EventClass = TE.trace_event_id
WHERE T.DatabaseName = 'DB Name' and T.ObjectName = 'Table Name'
ORDER BY T.StartTime
2016/03/22 01:36 2016/03/22 01:36

덧글을 달아 주세요