SQL Server Profiler Trace

--Import multiple trace file in sql Table.

--All the rollover files will be automatically imported

--provide number tracefile to capture all the rollver trace file details

SELECT * INTO temp_trc

FROM fn_trace_gettable('\\servername\trace_upgrade2022\dbname\tracefilename.trc', 153);

GO

--verify all the data is imported

select max (EndTime) from temp_trc

go

select min (EndTime) from temp_trc

--Import data in final table to review

SELECT DISTINCT NTUserName, HostName, LoginName, ServerName, ObjectName, DatabaseName, SessionLoginName

Into final_tablename

FROM temp_trc;