Microsoft KB Archive/273972

= BUG: fn_trace_gettable Function Cannot Read Rollover Files Generated by SQL Profiler =

Article ID: 273972

Article Last Modified on 10/17/2003

-

APPLIES TO


 * Microsoft SQL Server 2000 Standard Edition

-



This article was previously published under Q273972



BUG # 235519 (SHILOH_BUGS)



SYMPTOMS
SQL Server 2000 Profiler provides an option for rolling over files if a predefined maximum size per trace file is reached. SQL Server 2000 Profiler also provides a system defined function, fn_trace_gettable that you can use to load trace files to database tables. You cannot use the fn_trace_gettable function to load rolled over files generated by the graphical user interface (GUI) Profiler because that results in the following error message:

Server: Msg 567, Level 16, State 2, Line 1

File 'd:\test_1.trc' either does not exist or is not a recognizable

trace file. Or there was an error opening the file.



WORKAROUND
Use the system stored procedures to create the trace and enable the file rollover option. Then, use the fn_trace_gettable function to load the traces into a database table.



STATUS
Microsoft has confirmed this to be a problem in SQL Server 2000.