Hi,

Thank you so much for your response... I'm able to set the trace and run and it does creates multiple files but I'm unable to load all of the .trc files data to tables...

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...

I created a job with 3 steps:

1) Stop the trace

2) Load into table

3) Use xp_cmdshell to delete the .trc file

But this doesn't seem to be working 🙁

Can you please help me to build this job as this looks quite simple but isn't and at the same time is quite critical aspect for this task..

Cheers,

Nivedita