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

View products that this article applies to.

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.

Back to the top

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.

Back to the top

STATUS

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

Back to the top

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 (http://support.microsoft.com/kb/270599/EN-US/ ) HOW TO: Programmatically Load Trace Files into Tables

Back to the top