Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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 |
20307 |
Sequence |
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 |