locked
Encrypt Audit Trace (.trc) files. RRS feed

  • Question

  • Is there an easy way to encrypt sql server audit trace files (.trc)?

    Or is there a way to direct trace data directly into a table?
    Tuesday, January 17, 2017 7:02 PM

Answers

  • No, to both. Directing them synchronously to a table is considered to be a design flaw. You can import them asynchronously using

    SELECT *
    FROM fn_trace_gettable('C:\temp\TraceFile.trc', default) Trace

    Tuesday, January 17, 2017 7:11 PM

All replies

  • No, to both. Directing them synchronously to a table is considered to be a design flaw. You can import them asynchronously using

    SELECT *
    FROM fn_trace_gettable('C:\temp\TraceFile.trc', default) Trace

    Tuesday, January 17, 2017 7:11 PM
  • Are you referring to SQL Serer Audit files instead of trace files? SQL Audit files have an extension of .Sqlaudit.

    You also might want to look at SQL Auditing to audit what is going on in your database. - Sunit - thanks for the reminder about how to store traces synchronously from profiler to a table - It is not a best practice though:)


    Tuesday, January 17, 2017 7:58 PM
  • Thanks Hillary.. misread the question... time for a morning coffee maybe.. ;)
    Tuesday, January 17, 2017 8:31 PM
  • Thanks for the input.
    • Marked as answer by BFW001 Tuesday, January 17, 2017 8:40 PM
    • Unmarked as answer by Naomi N Tuesday, January 17, 2017 11:26 PM
    Tuesday, January 17, 2017 8:37 PM