fn_trace_gettable (Transact-SQL)

Returns the content of one or more trace files in tabular form.

Transact-SQL Syntax Conventions

Syntax

fn_trace_gettable ( filename , number_files )

Arguments

• filename
  Specifies the initial trace file to be read. filename is nvarchar(256), with no default.

• number_files
  Specifies the number of rollover files to be read. This number includes the initial file specified in filename. number_files is an int.

Remarks

If number_files is specified as default, fn_trace_gettable reads all rollover files until it reaches the end of the trace. fn_trace_gettable returns a table with all the columns valid for the specified trace. For more information, see sp_trace_setevent (Transact-SQL).

This function can read a trace that is still active on the instance on which it is executed.

Permissions

Requires ALTER TRACE permission on the server.

Examples

A. Using fn_trace_gettable to import rows from a trace file

The following example calls fn_trace_gettable inside the FROM clause of a SELECT...INTO statement.

USE AdventureWorks;
GO
SELECT * INTO temp_trc
FROM fn_trace_gettable('c:\temp\my_trace.trc', default);
GO

B. Using fn_trace_gettable to return a table with an IDENTITY column that can be loaded into a SQL Server table

The following example calls the function as part of a SELECT...INTO statement and returns a table with an IDENTITY column that can be loaded into the table temp_trc.

USE AdventureWorks;
GO
SELECT IDENTITY(int, 1, 1) AS RowNumber, * INTO temp_trc
FROM fn_trace_gettable('c:\temp\my_trace.trc', default);
GO

See Also

Reference

sp_trace_generateevent (Transact-SQL)
sp_trace_setevent (Transact-SQL)
sp_trace_setfilter (Transact-SQL)
sp_trace_setstatus (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance