This topic has not yet been rated - Rate this topic

snapshots.fn_trace_gettable (Transact-SQL)

SQL Server 2008

This function returns all the events captured for the specified trace.

Topic link icon Transact-SQL Syntax Conventions


snapshots.fn_trace_gettable ( trace_info_id, start_time, end_time )

Arguments

trace_info_id: The unique identifier for the primary key in the snapshots.trace_info table in the management data warehouse database. trace_info_id is int.
start_time: The time that the trace started. start_time is datetime.
end_time: The time that the trace ended. end_time is datetime.

Table Returned

Column name	Data type	Description
<All trace columns>	<Varies>	The trace data from the snapshots.trace_data table in the management data warehouse database. A list of the columns for the specified trace can be obtained by using the following query: Copy SELECT * FROM sys.trace_columns Note The columns that are returned by the snapshots.fn_trace_gettable function correspond to the values in the name column in the sys.trace_columns system view. The only difference is that the GroupID column is not returned by the function.

Column name

Data type

Description

The trace data from the snapshots.trace_data table in the management data warehouse database.

A list of the columns for the specified trace can be obtained by using the following query:

SELECT * FROM sys.trace_columns

Note

The columns that are returned by the snapshots.fn_trace_gettable function correspond to the values in the name column in the sys.trace_columns system view. The only difference is that the GroupID column is not returned by the function.

Permissions

Requires SELECT permission for mdw_reader.

Other Resources

Collector Types

Data Collection

Change History

Updated content
Updated the function name from snapshots.fn_trace_getdata to snapshots.fn_trace_gettable.
Removed the snapshot_id and trace_info_id columns from the Table Returned section.

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)

Community Additions

ADD