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