Microsoft SQL Server 2005 New Features

Chapter 1: Database Architecture and Storage Engine Features

Table 1-1: Some New Permissions in SQL Server 2005

Chapter 2: Database Administration and Development Tools

Table 2-1: Sqlcmd Extended Variables

Table 2-2: Sqlcmd Extended Utilities

Chapter 4: Programmability Features

Table 4-1: Required UDT Methods

Table 4-2: Required Aggregate Methods

Table 4-3: CLR Database Object Security Options

Chapter 5: Notification Services

Table 5-1: Nscontrol Commands

Chapter 6: SQL Server Service Broker

Table 6-1: T-SQL Statements for SQL Server Service Broker Objects

Table 6-2: T-SQL Statements for SQL Server Service Broker Messages

Table 6-3: Options for sp_configure

Table 6-4: New Service Broker Catalog Views

Chapter 7: XML Integration

Table 7-1: SQL Server 2005 XML Catalog Views

Chapter 9: Integration Services

Table 9-1: Integration Services System Variables

Table 9-2: Built-in Data Adapters

Table 9-3: Integration Services Container Types

Table 9-4: Integration Services Tasks

Table 9-5: Built-in Standard Transformations

Table 9-6: Integration Services Event Handlers

Table 9-7: Log Providers

Appendix A: Installation and Upgrading

Table A-1: System Checks

Table A-2: SQL Server 2005 Services

Table A-3: SQL Server 2005 Log Files

Table A-4: SQL Server 2005 Upgrade Options

Appendix B: Quick Facts

Table B-1: System Maximum Limits

Table B-2: Database Maximum Limits

Table B-3: Tables

Table B-4: Columns

Table B-5: T-SQL Maximum Limits