Share via

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)

Help and Information

Getting SQL Server 2005 Assistance