ObjectType Trace Event Column

 

Applies To: SQL Server 2016

The Object Type trace event column is used in a variety of trace events. This topic describes the possible values of this column and their associated definitions.

ValueDefinition
8259Check Constraint
8260Default (constraint or standalone)
8262Foreign-key Constraint
8272Stored Procedure
8274Rule
8275System Table
8276Trigger on Server
8277(User-defined) Table
8278View
8280Extended Stored Procedure
16724CLR Trigger
16964Database
16975Object
17222FullText Catalog
17232CLR Stored Procedure
17235Schema
17475Credential
17491DDL Event
17741Management Event
17747Security Event
17749User Event
17985CLR Aggregate Function
17993Inline Table-valued SQL Function
18000Partition Function
18002Replication Filter Procedure
18004Table-valued SQL Function
18259Server Role
18263Microsoft Windows Group
19265Asymmetric Key
19277Master Key
19280Primary Key
19283ObfusKey
19521Asymmetric Key Login
19523Certificate Login
19538Role
19539SQL Login
19543Windows Login
20034Remote Service Binding
20036Event Notification on Database
20037Event Notification
20038Scalar SQL Function
20047Event Notification on Object
20051Synonym
20307Sequence
20549End Point
20801Adhoc Queries which may be cached
20816Prepared Queries which may be cached
20819Service Broker Service Queue
20821Unique Constraint
21057Application Role
21059Certificate
21075Server
21076Transact-SQL Trigger
21313Assembly
21318CLR Scalar Function
21321Inline scalar SQL Function
21328Partition Scheme
21333User
21571Service Broker Service Contract
21572Trigger on Database
21574CLR Table-valued Function
21577Internal Table (For example, XML Node Table, Queue Table.)
21581Service Broker Message Type
21586Service Broker Route
21587Statistics
21825

21827

21831

21843

21847
User
22099Service Broker Service
22601Index
22604Certificate Login
22611XMLSchema
22868Type

sp_trace_setevent (Transact-SQL)

Community Additions

ADD
Show: