Results 1 to 4 of 4

Thread: SQL Profiler Trace: any history record for trace file rollover in the database server

  1. #1
    Join Date
    Mar 2003
    Location
    Hong Kong
    Posts
    8

    SQL Profiler Trace: any history record for trace file rollover in the database server

    Dear All,

    I am setting up the SQL Profiler trace to capture the database audit information. The trace information is written to the trace file in the OS and we have enabled the rollover option. I would like to know if I can find out when the rollover occurs. Can I find that information in any table in the database server?

    Thanks a lot,
    -- Chris

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    Check timestamp of trace file.

  3. #3
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    You can query sys.fn_trace_getinfo table to get status on currently running trace.

  4. #4
    Join Date
    Mar 2003
    Location
    Hong Kong
    Posts
    8
    Thanks a lot for the suggestions.

    Regards,
    -- Chris

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •