Default trace log

select * from sys.trace_events
select * from sys.trace_categories
select * from trace_columns
select * from traces
select * from trace_event_bindings
select * from trace_subclass_values

--check Default Trace enable or disable
SELECT * FROM sys.configurations WHERE configuration_id = 1568 

DECLARE @filePath Nvarchar(MAX)

SELECT @filePath = path FROM sys.traces WHERE id = 1

SELECT TOP (100)

　　ftgt.HostName,

　　ftgt.ServerName,

　　ftgt.DatabaseName,

　　ftgt.SPID,

　　ftgt.ObjectName

　　ftgt.ObjectType,

　　tsv.subclass_name

　　te.category_id,

　　tc.name,

　　ftgt.EventClass,

　　ftgt.LoginName,

　　ftgt.ApplicationName,

　　ftgt.startTime,

　　ftgt.TextData

FROM fn_trace_get_table(@filePath,Default) ftgt

　　LFET JOIN sys.trace_subclass_values tsv ON ftgt.EventClass = tsv.trace_event_id

　　INNER JOIN sys.trace_event te ON ftgt.EventClass = te.trace_event_id

　　INNER JOIN sys.trace_categories tc ON te.category_id = tc.category_id

WHERE ftgt.SPID > 50

AND te.category_id = 5

ORDER BY

　　StartTime DESC