Microsoft SQL Server 2008 R2 Unleashed- P20

Microsoft SQL Server 2008 R2 Unleashed- P20:SQL Server 2005 provided a number of significant new features and enhancements over what was available in SQL Server 2000. This is not too surprising considering there was a five-year gap between these major SQL Server 2008 is not as much of a quantum leap forward from SQL Server 2005 | 144 CHAPTER 6 SQL Server Profiler TABLE Trace Events and Their Related Categories trace_event _id Event Name Category Name 82 UserConfigurable 0 User configurable 83 UserConfigurable 1 User configurable 84 UserConfigurable 2 User configurable 85 UserConfigurable 3 User configurable 86 UserConfigurable 4 User configurable 87 UserConfigurable 5 User configurable 88 UserConfigurable 6 User configurable 89 UserConfigurable 7 User configurable 90 UserConfigurable 8 User configurable 91 UserConfigurable 9 User configurable 92 Data File Auto Grow Database 93 Log File Auto Grow Database 94 Data File Auto Shrink Database 95 Log File Auto Shrink Database 96 Showplan Text Performance 97 Showplan All Performance 98 Showplan Statistics Profile Performance 100 RPC Output Parameter Stored Procedures 102 Audit Database Scope GDR Event Security Audit 103 Audit Schema Object GDR Event Security Audit 104 Audit Addlogin Event Security Audit 105 Audit Login GDR Event Security Audit 106 Audit Login Change Property Event Security Audit 107 Audit Login Change Password Event Security Audit 108 Audit Add Login to Server Role Event Security Audit Download from Defining Server-Side Traces 145 TABLE Trace Events and Their Related Categories trace_event _id Event Name Category Name 109 Audit Add DB User Event Security Audit 110 Audit Add Member to DB Role Event Security Audit 111 Audit Add Role Event Security Audit 112 Audit App Role Change Password Event Security Audit 113 Audit Statement Permission Event Security Audit 114 Audit Schema Object Access Event Security Audit 115 Audit Backup Restore Event Security Audit 116 Audit DBCC Event Security Audit 117 Audit Change Audit Event Security Audit 118 Audit Object Derived Permission Event Security Audit 119 OLEDB Call Event OLEDB 120 OLEDB Queryinterface Event OLEDB 121 OLEDB DataRead Event OLEDB 122 Showplan XML Performance 123 SQL FullTextQuery Performance 124 Broker Conversation Broker 125 Deprecation Announcement .