With CTP5 we now have shipped most of the features that we will deliver in SQL Server 2008. You can download CTP5 from the Microsoft Download Center.

Improvements you’ll find:

• Data Collection and Performance Warehouse for Relational Engine

• Service Broker Enhancements

• Registered Servers Enhancements

• Synchronous net-changes change tracking for SQL Server

• T-SQL IntelliSense

• Declarative Management Framework (DMF) Enhancements

• Geo-spatial Support

• Analysis Services Query and Writeback Performance (FITS)

• Robust Report Server Platform

• Integration Services - Lookup Enhancements

• Analysis Services MDX Query Optimizer - Block Computation

• Analysis Services Aggregation Design

• Analysis Services Cube Design

• Reporting Services Scale Engine and Robust Server Fit and Finish (November CTP)

To learn more about what’s new in SQL Server 2008, see SQL Server 2008 Product Overview.