In SQL Server, how to move/import a multiple .trc files to a trace table

Question

I have a set of rollover .trc files recorded with Sql Profiler.

mytrace.trc

mytrace_1.trc

mytrace_2.trc

mytrace_3.trc

I can import the first one using this command:

use [my-database]
SELECT * INTO trace_folder
FROM::fn_trace_gettable('C:\mytrace.trc', 4)

However, this only appears to load the first file, not all four.

Answer 1

You'll want to use fn_trace_gettable:

From http://msdn.microsoft.com/en-us/library/ms188425.aspx:

USE AdventureWorks;
GO
SELECT * INTO temp_trc
FROM fn_trace_gettable('c:\temp\mytrace.trc', default);
GO