Results 1 to 2 of 2
  1. #1
    Join Date
    May 2002

    Unanswered: Reading C2 Audit files

    I have created a C2 Audit .trc file in sql server 2000 windows platform. i would like to be able to read it. I have tried the following but i get a message that the file does not exist or is not a recognizable trace file format or there was an error opening the file.

    SELECT * FROM ::fn_trace_gettable('D:\Program Files\Microsoft SQL
    Server\MSSQL\Data\audittrace_20070207073931.trc', default)

    I know the file and the path are valid. what else could be the problem??

  2. #2
    Join Date
    Jan 2004
    In a large office with bad lighting
    if the trace was interrupted and not closed cleanly, you will see this problem. How was the trace stopped ... a system reboot or stopping sql server?

    -- This is all just a Figment of my Imagination --

Posting Permissions

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