One Orange Chip
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)
--Chris Hedgate http://www.hedgate.net/Contributor to the Best of SQL Server Central volumesArticles: http://www.sqlservercentral.com/columnists/chedgate/
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.
SQLAndy - My Blog!
Connect with me on LinkedIn
Follow me on Twitter
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.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply