1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206
| DECLARE @events TABLE
(
event_id tinyint
, event_name sysname
)
INSERT @events VALUES (0, 'Reserved')
, (1, 'Reserved')
, (2, 'Reserved')
, (3, 'Reserved')
, (4, 'Reserved')
, (5, 'Reserved')
, (6, 'Reserved')
, (7, 'Reserved')
, (8, 'Reserved')
, (9, 'Reserved')
, (10, 'RPC:Completed')
, (11, 'RPC:Starting')
, (12, 'SQL:BatchCompleted')
, (13, 'SQL:BatchStarting')
, (14, 'Audit Login')
, (15, 'Audit Logout')
, (16, 'Attention')
, (17, 'ExistingConnection')
, (18, 'Audit Server Starts and Stops')
, (19, 'DTCTransaction')
, (20, 'Audit Login Failed')
, (21, 'EventLog')
, (22, 'ErrorLog')
, (23, 'Lock:Released')
, (24, 'Lock:Acquired')
, (25, 'Lock:Deadlock')
, (26, 'Lock:Cancel')
, (27, 'Lock:Timeout')
, (28, 'Degree of Parallelism Event (7.0 Insert)')
, (29, 'Reserved')
, (30, 'Reserved')
, (31, 'Reserved')
, (32, 'Reserved')
, (33, 'Exception')
, (34, 'SP:CacheMiss')
, (35, 'SP:CacheInsert')
, (36, 'SP:CacheRemove')
, (37, 'SP:Recompile')
, (38, 'SP:CacheHit')
, (39, 'Deprecated')
, (40, 'SQL:StmtStarting')
, (41, 'SQL:StmtCompleted')
, (42, 'SP:Starting')
, (43, 'SP:Completed')
, (44, 'SP:StmtStarting')
, (45, 'SP:StmtCompleted')
, (46, 'Object:Created')
, (47, 'Object:Deleted')
, (48, 'Reserved')
, (49, 'Reserved')
, (50, 'SQL Transaction')
, (51, 'Scan:Started')
, (52, 'Scan:Stopped')
, (53, 'CursorOpen')
, (54, 'TransactionLog')
, (55, 'Hash Warning')
, (56, 'Reserved')
, (57, 'Reserved')
, (58, 'Auto Stats')
, (59, 'Lock:Deadlock Chain')
, (60, 'Lock:Escalation')
, (61, 'OLE DB Errors')
, (62, 'Reserved')
, (63, 'Reserved')
, (64, 'Reserved')
, (65, 'Reserved')
, (66, 'Reserved')
, (67, 'Execution Warnings')
, (68, 'Showplan Text (Unencoded)')
, (69, 'Sort Warnings')
, (70, 'CursorPrepare')
, (71, 'Prepare SQL')
, (72, 'Exec Prepared SQL')
, (73, 'Unprepare SQL')
, (74, 'CursorExecute')
, (75, 'CursorRecompile')
, (76, 'CursorImplicitConversion')
, (77, 'CursorUnprepare')
, (78, 'CursorClose')
, (79, 'Missing Column Statistics')
, (80, 'Missing Join Predicate')
, (81, 'Server Memory Change')
, (82, 'User Configurable (0-9)')
, (83, 'User Configurable (0-9)')
, (84, 'User Configurable (0-9)')
, (85, 'User Configurable (0-9)')
, (86, 'User Configurable (0-9)')
, (87, 'User Configurable (0-9)')
, (88, 'User Configurable (0-9)')
, (89, 'User Configurable (0-9)')
, (90, 'User Configurable (0-9)')
, (91, 'User Configurable (0-9)')
, (92, 'Data File Auto Grow')
, (93, 'Log File Auto Grow')
, (94, 'Data File Auto Shrink')
, (95, 'Log File Auto Shrink')
, (96, 'Showplan Text')
, (97, 'Showplan All')
, (98, 'Showplan Statistics Profile')
, (99, 'Reserved')
, (100, 'RPC Output Parameter')
, (101, 'Reserved')
, (102, 'Audit Statement GDR Event')
, (103, 'Audit Object GDR Event')
, (104, 'Audit AddLogin Event')
, (105, 'Audit Login GDR Event')
, (106, 'Audit Login Change Property Event')
, (107, 'Audit Login Change Password Event')
, (108, 'Audit Add Login to Server Role Event')
, (109, 'Audit Add DB User Event')
, (110, 'Audit Add Member to DB Role Event')
, (111, 'Audit Add Role Event')
, (112, 'Audit App Role Change Password Event')
, (113, 'Audit Statement Permission Event')
, (114, 'Audit Schema Object Access Event')
, (115, 'Audit Backup/Restore Event')
, (116, 'Audit DBCC Event')
, (117, 'Audit Change Audit Event')
, (118, 'Audit Object Derived Permission Event')
, (119, 'OLEDB Call Event')
, (120, 'OLEDB QueryInterface Event')
, (121, 'OLEDB DataRead Event')
, (122, 'Showplan XML')
, (123, 'SQL:FullTextQuery')
, (124, 'Broker:Conversation')
, (125, 'Deprecation Announcement')
, (126, 'Deprecation Final Support')
, (127, 'Exchange Spill Event')
, (128, 'Audit Database Management Event')
, (129, 'Audit Database Object Management Event')
, (130, 'Audit Database Principal Management Event')
, (131, 'Audit Schema Object Management Event')
, (132, 'Audit Server Principal Impersonation Event')
, (133, 'Audit Database Principal Impersonation Event')
, (134, 'Audit Server Object Take Ownership Event')
, (135, 'Audit Database Object Take Ownership Event')
, (136, 'Broker:Conversation Group')
, (137, 'Blocked Process Report')
, (138, 'Broker:Connection')
, (139, 'Broker:Forwarded Message Sent')
, (140, 'Broker:Forwarded Message Dropped')
, (141, 'Broker:Message Classify')
, (142, 'Broker:Transmission')
, (143, 'Broker:Queue Disabled')
, (144, 'Reserved')
, (145, 'Reserved')
, (146, 'Showplan XML Statistics Profile')
, (148, 'Deadlock Graph')
, (149, 'Broker:Remote Message Acknowledgement')
, (150, 'Trace File Close')
, (151, 'Reserved')
, (152, 'Audit Change Database Owner')
, (153, 'Audit Schema Object Take Ownership Event')
, (154, 'Reserved')
, (155, 'FT:Crawl Started')
, (156, 'FT:Crawl Stopped')
, (157, 'FT:Crawl Aborted')
, (158, 'Audit Broker Conversation')
, (159, 'Audit Broker Login')
, (160, 'Broker:Message Undeliverable')
, (161, 'Broker:Corrupted Message')
, (162, 'User Error Message')
, (163, 'Broker:Activation')
, (164, 'Object:Altered')
, (165, 'Performance statistics')
, (166, 'SQL:StmtRecompile')
, (167, 'Database Mirroring State Change')
, (168, 'Showplan XML For Query Compile')
, (169, 'Showplan All For Query Compile')
, (170, 'Audit Server Scope GDR Event')
, (171, 'Audit Server Object GDR Event')
, (172, 'Audit Database Object GDR Event')
, (173, 'Audit Server Operation Event')
, (175, 'Audit Server Alter Trace Event')
, (176, 'Audit Server Object Management Event')
, (177, 'Audit Server Principal Management Event')
, (178, 'Audit Database Operation Event')
, (180, 'Audit Database Object Access Event')
, (181, 'TM: Begin Tran starting')
, (182, 'TM: Begin Tran completed')
, (183, 'TM: Promote Tran starting')
, (184, 'TM: Promote Tran completed')
, (185, 'TM: Commit Tran starting')
, (186, 'TM: Commit Tran completed')
, (187, 'TM: Rollback Tran starting')
, (188, 'TM: Rollback Tran completed')
, (189, 'Lock:Timeout (timeout > 0)')
, (190, 'Progress Report: Online Index Operation')
, (191, 'TM: Save Tran starting')
, (192, 'TM: Save Tran completed')
, (193, 'Background Job Error')
, (194, 'OLEDB Provider Information')
, (195, 'Mount Tape')
, (196, 'Assembly Load')
, (197, 'Reserved')
, (198, 'XQuery Static Type')
, (199, 'QN: subscription')
, (200, 'QN: parameter table')
, (201, 'QN: template')
, (202, 'QN: dynamics') |
Partager