sys.trace_event_bindings

Description

catalog view contains a list of all possible usage combinations of events and columns. For each event listed in the column. Not all available columns are populated each time a given event occurs. These values do not change for a given version of the SQL Server Database For a complete list of supported trace events, see SQL Server Event Class Reference ID of the trace event.

Syntax

sp_trace_create sp_trace_setevent sp_trace_setfilter sp_trace_setstatus

Permissions

Article • 02/28/2023 The catalog view contains a list of all possible usage combinations of events and columns. For each event listed in the column, all available columns are listed in the column. Not all available columns are populated each time a given event occurs. These values do not change for a given version of the SQL Server Database Engine. For a complete list of supported trace events, see SQL Server Event Class Reference. Description ID of the trace event. This column is also in the catalog view. ID of the trace column. This column is also in the catalog view. The visibility of the metadata in catalog views is limited to securables that a user either owns, or on which the user was granted some permission. For more information, see Metadata Visibility Configuration. Object Catalog Views (Transact-SQL) sys.traces (Transact-SQL) sys.trace_categories (Transact-SQL) sys.trace_columns (Transact-SQL) ） Important This feature will be removed in a future version of SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Use Extended Event catalog views instead. ﾉ Expand table See Also sys.trace_event_bindings (Transact-SQL) sys.trace_subclass_values (Transact-SQL) Article • 02/28/2023 The catalog view contains a list of all SQL trace events. These trace events do not change for a given version of the SQL Server Database Engine. For more information about these trace events, see SQL Server Event Class Reference. Description Unique ID of the event. This column is also in the and catalog views. Category ID of the event. This column is also in the catalog view. Unique name of this event. This parameter is not localized. The visibility of the metadata in catalog views is limited to securables that a user either owns, or on which the user was granted some permission. For more information, see Metadata Visibility Configuration. Object Catalog Views (Transact-SQL) sys.traces (Transact-SQL) sys.trace_categories (Transact-SQL) sys.trace_columns (Transact-SQL) ） Important This feature will be removed in a future version of SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature. Use Extended Event catalog views instead. ﾉ Expand table See also sys.trace_events (Transact-SQL) sys.trace_event_bindings (Transact-SQL) Category Deprecated feature Replacement Feature name Other DB-Library Embedded SQL for C Although the Database Engine still supports connections from existing applications that use the DB-Library and Embedded SQL APIs, it doesn’t include the files or documentation required to do programming work on applications that use these APIs. A future version of the SQL Server Database Engine will drop support for connections from DB-Library or Embedded SQL applications. Don’t use DB- Library or Embedded SQL to develop new applications. Remove any dependencies on either DB-Library or Embedded SQL when you modify existing applications. Instead of these APIs, use the SQLClient namespace or an API such as ODBC. The current version doesn’t include the DB-Library DLL required to run these applications. To run DB-Library or Embedded SQL applications, you must have available the DB-Library DLL from SQL Server version 6.5, SQL Server 7.0, or SQL Server 2000 (8.x). None Tools SQL Server Profiler for Trace Capture Use Extended Events Profiler embedded in SQL Server Management Studio. SQL Server Profiler Tools SQL Server Profiler for Trace Replay SQL Server Distributed Replay overview SQL Server Profiler Trace Management Objects Microsoft.SqlServer.Management.Trace namespace (contains the APIs for SQL Server Trace and Replay objects) Trace Configuration: Microsoft.SqlServer.Management.XEvent Trace Reading: Microsoft.SqlServer.XEvent.Linq Trace Replay: None SQL Trace stored procedures, functions, and catalog views fn_trace_geteventinfo fn_trace_getfilterinfo fn_trace_getinfo fn_trace_gettable sys.trace_categories sys.trace_columns sys.trace_subclass_values Extended Events overview fn_trace_geteventinfo fn_trace_getfilterinfo fn_trace_getinfo fn_trace_gettable Set options for , , and statements keyword ７ Note The cookie parameter for is currently documented as varbinary(8000) which is the correct maximum length. However the current implementation returns varbinary(50). If developers have allocated varbinary(50) the application might require changes if the