-
SQL 2000 Trace
Hi,
I created a trace use sp_trace_create, syntax is :
exec sp_trace_create @traceid = @trace_id output,
@options = 2, --
TRACE_FILE_ROLLOVER
@tracefile = 'c: race_test',
@maxfilesize = 100
also I set the trace filter, trace event to log all the messages which
severity >= 10, then I run the trace. The problem is it seems like it
will only write to the file after certain size, I haven't figure out how
many errors it need to initialize the writing to the file. If I stop and
delete the trace, it will write to the file at that time. Can anyone
tell me why? Also does anyone know how to save the trace destination
directly to a table(in Transact-sql, not from profile) like SQL 7.0.
Regards,
Heidi Zhang
hzhangcti@usa.net
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|