Read all trace file data and print the action performed

• SQL_Hunt

  SSC-Dedicated

  Points: 33518

  More actions

  November 12, 2014 at 4:45 am

  #298566

  Comments posted to this topic are about the item Read all trace file data and print the action performed

  Thanks.

• akljfhnlaflkj

  SSC Guru

  Points: 76202

  More actions

  May 11, 2015 at 1:27 pm

  #1797082

  Thanks, I'll check this out.

• Lee Linares

  SSCrazy

  Points: 2723

  More actions

  September 13, 2016 at 7:35 am

  #1900539

  Thanks for taking the time to share this with everyone. I did run into a problem though. I would get an error message similar to this:

  Msg 567, Level 16, State 5, Line 36

  File 'xxxxxx' either does not exist or is not a recognizable trace file. Or there was an error opening the file.

  I found that if you change this line of code:

  SET @CMD = 'DIR ' + @tracelocation + '*.TRC' + ' /B'

  To this (adding double-quotes):

  SET @CMD = 'DIR "' + @tracelocation + '*.TRC"' + ' /B'

  Then it works fine. Thanks.

  Lee