What is this "insert into #temp_trace" SQL query used for?
说明
The SQL statement is executed on SQL Server databases by the SQL Server agent. What it is for?
insert into #temp_trace select top 100 TextData , LoginName , StartTime , EventClass from ::fn_trace_gettable( @base_tracefilename, default) where ((EventClass = 22 and Error = 15457 and severity=10) or (EventClass = 116 and TextData like '%TRACEO%(%')) and StartTime between @from_date and @to_date order by StartTime desc
解决办法
This query is part of the SQL PI Change Tracking Default Trace Configuration.
This SQL checks for configuration changes captured by the default trace as described in KB article 4226535