July 17, 2001 at 4:22 am
Does anyone know if it is possible to create a server side trace that logs directly to a table instead of a trace file, using sp_trace_create.
Chris Hedgate @ Apptus Technologies (http://www.apptus.se)
July 17, 2001 at 9:05 am
Not in SQL2K. Im most of the way through writing a script that writes it to a file, then when I run the script again stops the trace, imports it to a table, then optionally restarts the trace. A lot more work than it should be I think.
Andy
July 17, 2001 at 9:31 am
OK, that's what I thought. My script starts by importing the last trace file created, and then starts a new trace that runs for 5 minutes and then quits by itself. Looking forward to your script.
Chris Hedgate @ Apptus Technologies (http://www.apptus.se)
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy