• On a different thought:

    I am in the process of auditing security events using a profiler scripts with the output going directly to a file (for all the reasons previously mentioned in this forum).

    The problem that I am running across is that the output to the trace file is being buffered (128K) and if a nasty outage occurs before the buffer is flushed (power supply, blue screen, whatever)then the audited security trace is being lost.

    I am new to SQL Server 2000, is there something obvious that I have missed (e.g. bypass buffered writes)?

    Any tips would be appreciated.