Updated: July 11, 2020 (April 13, 2009)

SP1 Arrives for SQL Server 2008

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

SQL Server 2008 SP1, released Apr. 2009, delivers relatively few changes and customers should be able to test and deploy it quickly. Support for “slipstreamed” installation will also simplify deployment of the service pack in organizations with large numbers of servers.

SP1 delivers fixes for bugs found since the Aug. 2008 launch of SQL Server 2008, including problems connecting to SQL Server clusters from Windows Vista and Windows Server 2008 computers, crashes of the SQL Server Agent service (which runs scheduled jobs) and Browser Service (which helps locate SQL Server instances on the network), and dropped rows in one of the product’s bulk data insert commands. Other fixes affect the database engine and the Analysis Services, Integration Services, and Reporting Services components. SP1 also adds ClickOnce over-the-Web deployment to the Report Builder design client; ClickOnce deployment was supported in the first version of the client (in SQL Server 2005) but not in the version that shipped with SQL Server 2008 in Oct. 2008.

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