Read all trace file data and print the action performed

  • SQL_Hunt

    SSC-Dedicated

    Points: 33450

    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

    Thanks, I'll check this out.

  • Lee Linares

    SSCrazy

    Points: 2693

    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

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply