nivedita talukdar (6/23/2013)As suggested I'm using this:
USE AdventureWorks;
GO
SELECT * INTO temp_trc
FROM fn_trace_gettable('c:\temp\mytrace.trc', default);
GO
But this doesn't copy or load all the .trc files...instead just does it for the first file and thus not satisfying my condition...
From the sample above, you should have files in your folder with names like "mytrace.trc", "mytrace_1.trc", "mytrace_3.trc", etc.
From the post with your trace-create statement you should have files in folder C:\PWB_test with names "T.trc", "T_1.trc", "T_2.trc", etc. Are these files present in the folder?
And if you change the "default" option to a specific number of files (example: 2), will it still load only one tracefile into the table?