BUG: fn_trace_gettable Function Cannot Read Rollover Files Generated by SQL Profiler (273972)

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.

REFERENCES

For more information about using the system stored procedures to trace, see the "Creating and Managing Traces and Templates" topic in SQL Server 2000 Books Online. For additional information about how to set up tracing by using the system stored procedures and for information about using the fn_trace_gettable function, click the following article number to view the article in the Microsoft Knowledge Base:

270599 HOW TO: Programmatically Load Trace Files into Tables