Updated: July 11, 2020 (March 19, 2007)

SQL Server Updated for Office 2007, Vista

As managing vice president, Rob Helm covers Microsoft collaboration and content management. His 25-plus years of experience analyzing Microsoft’s technology... more

The second service pack for Microsoft’s SQL Server 2005 database management system and business intelligence platform delivers new features as well as fixes. Notably, SQL Server 2005 SP2 improves SQL Server’s compatibility and integration with new products such as Windows Vista, Office 2007, and SharePoint Server. New features mean new code, however, so organizations will have to test SP2 for compatibility and stability just as they would a minor product release.

SP2’s 143 documented fixes are split roughly evenly between the product’s database management system (DBMS) features, and its business intelligence components, which include the following:

Analysis Services, used to analyze historical data in specialized databases (called cubes) for fast interactive analysis and automated data mining
Reporting Services, for designing and generating human-readable reports from databases and data warehouses and distributing of these reports to large numbers of users on an ongoing basis

Atlas Members have full access

Get access to this and thousands of other unbiased analyses, roadmaps, decision kits, infographics, reference guides, and more, all included with membership. Comprehensive access to the most in-depth and unbiased expertise for Microsoft enterprise decision-making is waiting.

Membership Options

Already have an account? Login Now