Comments posted to this topic are about the item Read all trace file data and print the action performed
Thanks, I'll check this out.
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.
Viewing 3 posts - 1 through 2 (of 2 total)