sys.events (Transact-SQL)
Contains a row for each event for which a trigger or event notification fires. These events represent the event types that are specified when the trigger or event notification is created by using CREATE TRIGGER or CREATE EVENT NOTIFICATION.
| Column name | Data type | Description |
|---|---|---|
object_id |
int |
ID of the trigger or event notification. This value, together with type, uniquely identifies the row. |
type |
int |
Type of event that causes the trigger to fire. For a list of events, see the following table. |
type_desc |
nvarchar(60) |
Description of the type of event that causes a trigger to fire. For a list of events, see the following table. |
is_trigger_event |
bit |
1 = Trigger event. 0 = Notification event. |
The following table contains a list of events and their related type number.
| type | type_desc |
|---|---|
1 |
INSERT |
2 |
UPDATE |
3 |
DELETE |
21 |
CREATE_TABLE |
22 |
ALTER_TABLE |
23 |
DROP_TABLE |
24 |
CREATE_INDEX |
25 |
ALTER_INDEX |
26 |
DROP_INDEX |
27 |
CREATE_STATISTICS |
28 |
UPDATE_STATISTICS |
29 |
DROP_STATISTICS |
34 |
CREATE_SYNONYM |
36 |
DROP_SYNONYM |
41 |
CREATE_VIEW |
42 |
ALTER_VIEW |
43 |
DROP_VIEW |
51 |
CREATE_PROCEDURE |
52 |
ALTER_PROCEDURE |
53 |
DROP_PROCEDURE |
61 |
CREATE_FUNCTION |
62 |
ALTER_FUNCTION |
63 |
DROP_FUNCTION |
71 |
CREATE_TRIGGER |
72 |
ALTER_TRIGGER |
73 |
DROP_TRIGGER |
74 |
CREATE_EVENT_NOTIFICATION |
76 |
DROP_EVENT_NOTIFICATION |
91 |
CREATE_TYPE |
93 |
DROP_TYPE |
101 |
CREATE_ASSEMBLY |
102 |
ALTER_ASSEMBLY |
103 |
DROP_ASSEMBLY |
131 |
CREATE_USER |
132 |
ALTER_USER |
133 |
DROP_USER |
134 |
CREATE_ROLE |
135 |
ALTER_ROLE |
136 |
DROP_ROLE |
137 |
CREATE_APPLICATION_ROLE |
138 |
ALTER_APPLICATION_ROLE |
139 |
DROP_APPLICATION_ROLE |
141 |
CREATE_SCHEMA |
142 |
ALTER_SCHEMA |
143 |
DROP_SCHEMA |
144 |
CREATE_LOGIN |
145 |
ALTER_LOGIN |
146 |
DROP_LOGIN |
151 |
CREATE_MESSAGE_TYPE |
152 |
ALTER_MESSAGE_TYPE |
153 |
DROP_MESSAGE_TYPE |
154 |
CREATE_CONTRACT |
156 |
DROP_CONTRACT |
157 |
CREATE_QUEUE |
158 |
ALTER_QUEUE |
159 |
DROP_QUEUE |
160 |
BROKER_QUEUE_DISABLED |
161 |
CREATE_SERVICE |
162 |
ALTER_SERVICE |
163 |
DROP_SERVICE |
164 |
CREATE_ROUTE |
165 |
ALTER_ROUTE |
166 |
DROP_ROUTE |
167 |
GRANT_SERVER |
168 |
DENY_SERVER |
169 |
REVOKE_SERVER |
170 |
GRANT_DATABASE |
171 |
DENY_DATABASE |
172 |
REVOKE_DATABASE |
173 |
QUEUE_ACTIVATION |
174 |
CREATE_REMOTE_SERVICE_BINDING |
175 |
ALTER_REMOTE_SERVICE_BINDING |
176 |
DROP_REMOTE_SERVICE_BINDING |
177 |
CREATE_XML_SCHEMA_COLLECTION |
178 |
ALTER_XML_SCHEMA_COLLECTION |
179 |
DROP_XML_SCHEMA_COLLECTION |
181 |
CREATE_ENDPOINT |
182 |
ALTER_ENDPOINT |
183 |
DROP_ENDPOINT |
191 |
CREATE_PARTITION_FUNCTION |
192 |
ALTER_PARTITION_FUNCTION |
193 |
DROP_PARTITION_FUNCTION |
194 |
CREATE_PARTITION_SCHEME |
195 |
ALTER_PARTITION_SCHEME |
196 |
DROP_PARTITION_SCHEME |
197 |
CREATE_CERTIFICATE |
198 |
ALTER_CERTIFICATE |
199 |
DROP_CERTIFICATE |
201 |
CREATE_DATABASE |
202 |
ALTER_DATABASE |
203 |
DROP_DATABASE |
204 |
ALTER_AUTHORIZATION_SERVER |
205 |
ALTER_AUTHORIZATION_DATABASE |
206 |
CREATE_XML_INDEX |
207 |
ADD_ROLE_MEMBER |
208 |
DROP_ROLE_MEMBER |
209 |
ADD_SERVER_ROLE_MEMBER |
210 |
DROP_SERVER_ROLE_MEMBER |
1014 |
AUDIT_LOGIN |
1015 |
AUDIT_LOGOUT |
1020 |
AUDIT_LOGIN_FAILED |
1021 |
EVENTLOG |
1022 |
ERRORLOG |
1025 |
LOCK_DEADLOCK |
1033 |
EXCEPTION |
1034 |
SP_CACHEMISS |
1035 |
SP_CACHEINSERT |
1036 |
SP_CACHEREMOVE |
1037 |
SP_RECOMPILE |
1046 |
OBJECT_CREATED |
1047 |
OBJECT_DELETED |
1055 |
HASH_WARNING |
1059 |
LOCK_DEADLOCK_CHAIN |
1060 |
LOCK_ESCALATION |
1061 |
OLEDB_ERRORS |
1067 |
EXECUTION_WARNINGS |
1069 |
SORT_WARNINGS |
1079 |
MISSING_COLUMN_STATISTICS |
1080 |
MISSING_JOIN_PREDICATE |
1081 |
SERVER_MEMORY_CHANGE |
1082 |
USERCONFIGURABLE_0 |
1083 |
USERCONFIGURABLE_1 |
1084 |
USERCONFIGURABLE_2 |
1085 |
USERCONFIGURABLE_3 |
1086 |
USERCONFIGURABLE_4 |
1087 |
USERCONFIGURABLE_5 |
1088 |
USERCONFIGURABLE_6 |
1089 |
USERCONFIGURABLE_7 |
1090 |
USERCONFIGURABLE_8 |
1091 |
USERCONFIGURABLE_9 |
1092 |
DATA_FILE_AUTO_GROW |
1093 |
LOG_FILE_AUTO_GROW |
1094 |
DATA_FILE_AUTO_SHRINK |
1095 |
LOG_FILE_AUTO_SHRINK |
1102 |
AUDIT_DATABASE_SCOPE_GDR_EVENT |
1103 |
AUDIT_SCHEMA_OBJECT_GDR_EVENT |
1104 |
AUDIT_ADDLOGIN_EVENT |
1105 |
AUDIT_LOGIN_GDR_EVENT |
1106 |
AUDIT_LOGIN_CHANGE_PROPERTY_EVENT |
1107 |
AUDIT_LOGIN_CHANGE_PASSWORD_EVENT |
1108 |
AUDIT_ADD_LOGIN_TO_SERVER_ROLE_EVENT |
1109 |
AUDIT_ADD_DB_USER_EVENT |
1110 |
AUDIT_ADD_MEMBER_TO_DB_ROLE_EVENT |
1111 |
AUDIT_ADD_ROLE_EVENT |
1112 |
AUDIT_APP_ROLE_CHANGE_PASSWORD_EVENT |
1114 |
AUDIT_SCHEMA_OBJECT_ACCESS_EVENT |
1115 |
AUDIT_BACKUP_RESTORE_EVENT |
1116 |
AUDIT_DBCC_EVENT |
1117 |
AUDIT_CHANGE_AUDIT_EVENT |
1119 |
OLEDB_CALL_EVENT |
1120 |
OLEDB_QUERYINTERFACE_EVENT |
1121 |
OLEDB_DATAREAD_EVENT |
1122 |
SHOWPLAN_XML |
1125 |
DEPRECATION_ANNOUNCEMENT |
1126 |
DEPRECATION_FINAL_SUPPORT |
1127 |
EXCHANGE_SPILL_EVENT |
1128 |
AUDIT_DATABASE_MANAGEMENT_EVENT |
1129 |
AUDIT_DATABASE_OBJECT_MANAGEMENT_EVENT |
1130 |
AUDIT_DATABASE_PRINCIPAL_MANAGEMENT_EVENT |
1131 |
AUDIT_SCHEMA_OBJECT_MANAGEMENT_EVENT |
1132 |
AUDIT_SERVER_PRINCIPAL_IMPERSONATION_EVENT |
1133 |
AUDIT_DATABASE_PRINCIPAL_IMPERSONATION_EVENT |
1134 |
AUDIT_SERVER_OBJECT_TAKE_OWNERSHIP_EVENT |
1135 |
AUDIT_DATABASE_OBJECT_TAKE_OWNERSHIP_EVENT |
1137 |
BLOCKED_PROCESS_REPORT |
1146 |
SHOWPLAN_XML_STATISTICS_PROFILE |
1148 |
DEADLOCK_GRAPH |
1150 |
TRACE_FILE_CLOSE |
1152 |
AUDIT_CHANGE_DATABASE_OWNER |
1153 |
AUDIT_SCHEMA_OBJECT_TAKE_OWNERSHIP_EVENT |
1155 |
FT_CRAWL_STARTED |
1156 |
FT_CRAWL_STOPPED |
1157 |
FT_CRAWL_ABORTED |
1162 |
USER_ERROR_MESSAGE |
1164 |
OBJECT_ALTERED |
1166 |
SQL_STMTRECOMPILE |
1167 |
DATABASE_MIRRORING_STATE_CHANGE |
1168 |
SHOWPLAN_XML_FOR_QUERY_COMPILE |
1169 |
SHOWPLAN_ALL_FOR_QUERY_COMPILE |
1170 |
AUDIT_SERVER_SCOPE_GDR_EVENT |
1171 |
AUDIT_SERVER_OBJECT_GDR_EVENT |
1172 |
AUDIT_DATABASE_OBJECT_GDR_EVENT |
1173 |
AUDIT_SERVER_OPERATION_EVENT |
1175 |
AUDIT_SERVER_ALTER_TRACE_EVENT |
1176 |
AUDIT_SERVER_OBJECT_MANAGEMENT_EVENT |
1177 |
AUDIT_SERVER_PRINCIPAL_MANAGEMENT_EVENT |
1178 |
AUDIT_DATABASE_OPERATION_EVENT |
1180 |
AUDIT_DATABASE_OBJECT_ACCESS_EVENT |
1194 |
OLEDB_PROVIDER_INFORMATION |
1195 |
MOUNT_TAPE |
1196 |
ASSEMBLY_LOAD |
1198 |
XQUERY_STATIC_TYPE |
1199 |
QN__SUBSCRIPTION |
1200 |
QN__PARAMETER_TABLE |
1201 |
QN__TEMPLATE |
1202 |
QN__DYNAMICS |
See Also
Reference
Object Catalog Views (Transact-SQL)
Catalog Views (Transact-SQL)