Hi,

I have the following question. I know that I can view the trace IDs and other relevant info after the trace was turned off:


sp_trace_setstatus 1, 0
sp_trace_setstatus 1, 2
select traceid, convert(nvarchar(255), value) from ::fn_trace_getinfo(default)

However, I need to know the traceIDs of the turned-on audit trace file. Is that possible to do through some system tables and/or views?

Any help will be greatly appreciated.

Thanks,
Alla