Reading Default Tracefile

Below are examples for Find Permission Changes In The Default Trace

Type1:

declare @tracefile varchar(100)

set @tracefile=(select * from ::fn_trace_getinfo(default) where traceid=1 and property=2 )

select * from sys.trace_events

select * from ::fn_trace_gettable('E:\MSSQL12.VAS1P\MSSQL\Log\log_15.trc',default) where TextData like ('%alter%')