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 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply