Reading Profiler data files in QA doesnt work!

• chefi

  SSC Journeyman

  Points: 85

  More actions

  July 20, 2004 at 5:51 am

  #152231

  I use Profiler to track database and server activity currently. I record the results in data files. Afterwards I try to read them with the following statement:

  select * from ::fn_trace_gettable('Trace server local path',default)

  Data grid displays results data correctly but an error message sometimes is displayed:

  Server encountered an error 'Trace server local path'.

  Has anybody experienced similar problem?

  Thanks in advance!

  Stefy

• Wesley Brown

  SSChampion

  Points: 12045

  More actions

  July 21, 2004 at 8:09 pm

  #515561

  The only time I've seen an error is if profiler or the trace isn't shut down properly. it causes the trace file to be incomplete.

   

  Wes