public
anonymous / gist:1626297
Created

  • Download Gist
gistfile1.txt
1 2 3 4 5 6 7 8
SELECT MAX(StartTime),
MIN(StartTime)
FROM sys.traces t
CROSS APPLY fn_trace_gettable(REVERSE(SUBSTRING(REVERSE(t.path),
CHARINDEX('\', REVERSE(t.path)),
260)
) + N'log.trc', DEFAULT) f
WHERE t.is_default = 1

Please sign in to comment on this gist.

Something went wrong with that request. Please try again.