Post reply

fn_trace_gettable error

  • October 10, 2005 at 4:32 pm

    #91753

    Hi,

    when I execute this command: select * from :: fn_trace_gettable(@cFileName,

    default), the sqlserver

    return all rows and a message error 'Server encountered an error

    'c:\Trace\DofW6.trc''. This turn impossible to save a rows in temporary

    table. Anybody know a cause this error?

     

    Server: Msg 568, Level 16, State 10, Line 1

    Server encountered an error 'F:\Audit\audit200510102234.trc'.

  • October 10, 2005 at 4:59 pm

    #596402

    I don't know are you sure the value in the parameter @cFileName is correct?

     

  • October 11, 2005 at 8:02 am

    #596537

    Yes i'm sure.

  • October 11, 2005 at 10:01 am

    #596573

    Was SQL Server restarted while the trace was running? If so, then the "trace stop" event was not written to the trace file and fn_trace_gettable will throw an error when the "trace stop" event does not exist.

    The work-around is to open the file using the SQL Profiler and then save the events to a table.

    SQL = Scarcely Qualifies as a Language

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply