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