Applies ToSQL Server 2008 Developer SQL Server 2008 Enterprise SQL Server 2008 Express SQL Server 2008 Express with Advanced Services SQL Server 2008 Standard SQL Server 2008 Web SQL Server 2008 Workgroup

INTRODUCTION

This article lists the Microsoft SQL Server 2008 builds that were released after Microsoft SQL Server 2008 Service Pack 1 (SP1) was released.

More Information

Build 10.00.2850.0 (cumulative update)

This cumulative update package was released on September 19, 2011.The parent build of this build is 10.00.2847.00. For more informationabout this build, click the following article number to view the article in the Microsoft Knowledge Base:

2582282 Cumulative update package 16 for SQL Server 2008 Service Pack 1

Build 10.00.2847.00 (cumulative update)

This cumulative update package was released on July 18, 2011.The parent build of this build is 10.00.2821. For more informationabout this build, click the following article number to view the article in the Microsoft Knowledge Base:

2555406 Cumulative update package 15 for SQL Server 2008 Service Pack 1

Build 10.00.2821.00 (cumulative update)

This cumulative update package was released on May 16, 2011.The parent build of this build is 10.00.2816. For more informationabout this build, click the following article number to view the article in the Microsoft Knowledge Base:

2527187 Cumulative update package 14 for SQL Server 2008 Service Pack 1

Build 10.00.2816.00 (cumulative update)

This cumulative update package was released on March 21, 2011.The parent build of this build is 10.00.2808. For more informationabout this build, click the following article number to view the article in the Microsoft Knowledge Base:

2497673 Cumulative update package 13 for SQL Server 2008 Service Pack 1

Build 10.00.2808 (cumulative update)

This cumulative update package was released on January 17, 2011.The parent build of this build is 10.00.2804. For more informationabout this build, click the following article number to view the article in the Microsoft Knowledge Base:

2467236 Cumulative update package 12 for SQL Server 2008 Service Pack 1

Build 10.00.2804 (cumulative update)

This cumulative update package was released on November 15, 2010.The parent build of this build is 10.00.2799. For more informationabout this build, click the following article number to view the article in the Microsoft Knowledge Base:

2413738 Cumulative update package 11 for SQL Server 2008 Service Pack 1

Build 10.00.2799 (cumulative update)

This cumulative update package was released on September 21, 2010.The parent build of this build is 10.00.2789. For more informationabout this build, click the following article number to view the article in the Microsoft Knowledge Base:

2279604 Cumulative update package 10 for SQL Server 2008 Service Pack 1

Build 10.00.2789 (cumulative update)

This cumulative update package was released on July 19, 2010.The parent build of this build is 10.00.2781. For more information about this build, click the following article number to view the article in the Microsoft Knowledge Base:

2083921 Cumulative update package 9 for SQL Server 2008 Service Pack 1

Build 10.00.2781

This build was released on June 10, 2010.The parent build of this build is 10.00.2775.This build contains the following SQL Server 2008 hotfix.

SQL VSTS bug number

Knowledge Base article number

Description

412292

980832

FIX: "A system assertion check has failed" error message when you run a Transaction-SQL query in Microsoft SQL Server 2008

Build 10.00.2775 (cumulative update)

This cumulative update package was released on May 17, 2010.The parent build of this build is 10.00.2773.For more information about this build, click the following article number to view the article in the Microsoft Knowledge Base:

981702 Cumulative update package 8 for SQL Server 2008 Service Pack 1

Build 10.00.2773

This build was released on May 8, 2010.The parent build of this build is 10.00.2770.This build contains the following SQL Server 2008 hotfix.

SQL VSTS bug number

Knowledge Base article number

Description

465350

FIX: The result of the query contains empty rows when you run a Multidimensional Expressions (MDX) query in Microsoft SQL Server Analysis Services 2008

Build 10.00.2770

This build was released on April 6, 2010.The parent build of this build is 10.00.2769.This build contains the following SQL Server 2008 hotfix.

SQL VSTS bug number

Knowledge Base article number

Description

430276

The DynamicHeight and DynamicWidth properties for a chart control in a tablix are incorrectly used for other charts in the same page in a SQL Server Reporting Services 2008 report

Build 10.00.2769

This build was released on March 30, 2010.The parent build of this build is 10.00.2766.This build contains the following SQL Server 2008 hotfix.

SQL VSTS bug number

Knowledge Base article number

Description

427778

An exception occurs when you export a SQL Server Reporting Services 2008 report that contains images or charts to an Excel file

Build 10.00.2766 (cumulative update)

This cumulative update package was released on March 15, 2010.The parent build of this build is 10.00.2763.For more information about this build, click the following article number to view the article in the Microsoft Knowledge Base:

979065 Cumulative update package 7 for SQL Server 2008 Service Pack 1

Build 10.00.2763

This build was released on March 11, 2010.The parent build of this build is 10.00.2760.This build contains the following SQL Server 2008 hotfix.

SQL VSTS bug number

Knowledge Base article number

Description

421581

A line break is appended to a text box when you export a SQL Server Reporting Services 2008 report to a Word file

Build 10.00.2760

This build was released on January 23, 2010.The parent build of this build is 10.00.2758.This build contains the following SQL Server 2008 hotfix.

SQL VSTS bug number

Knowledge Base article number

Description

402420

978839

FIX: A backup operation on a SQL Server 2008 database fails if you enable change tracking on this database

Build 10.00.2758

This build was released on Febury 4, 2010.The parent build of this build is 10.00.2757.This build contains the following SQL Server 2008 hotfixes.

SQL VSTS bug number

Knowledge Base article number

Description

399076399071

978791

FIX: Data loss may occur if the database mirroring thread stops responding for a long time during an automatic failover process in SQL Server 2005 or in SQL Server 2008

399074

978947

A non-yielding issue may cause a database mirroring failover in SQL Server 2005 and in SQL Server 2008

Build 10.00.2757 (cumulative update)

This cumulative update package was released on January 18, 2010. The parent build of this build is 10.00.2749. For more information about this build, click the following article number to view the article in the Microsoft Knowledge Base:

977443 Cumulative update package 6 for SQL Server 2008 Service Pack 1

Build 10.00.2749

This build was released on December 8, 2009.The parent build of this build is 10.00.2748.This build contains the following SQL Server 2008 hotfix.

SQL VSTS bug number

Knowledge Base article number

Description

380970

978070

FIX: The Measures.<X>.Dim folder is created unexpectedly when you use a non-admin user account to browse a cube in SQL Server 2008 Analysis Services

Build 10.00.2748

This build was released on November 27, 2009.The parent build of this build is 10.00.2746.This build contains the following SQL Server 2008 hotfix.

SQL VSTS bug number

Knowledge Base article number

Description

376397

975991

FIX: The DBCC CHECKFILEGROUP statement does not check a partitioned object if one of the partitions is not presented in the filegroup being checked in SQL Server 2008

Build 10.00.2746 (cumulative update)

This cumulative update package was released on November 16, 2009. The parent build of this build is 10.00.2734. For more information about this build, click the following article number to view the article in the Microsoft Knowledge Base:

975977 Cumulative update package 5 for SQL Server 2008 Service Pack 1

Build 10.00.2740

This build was released on November 4, 2009.The parent build of this build is 10.00.2734.This build contains the following SQL Server 2008 hotfix.

SQL VSTS bug number

Knowledge Base article number

Description

366638

976761

FIX: Error message when you perform a rolling upgrade in a SQL Server 2008 cluster : "18401, Login failed for user SQLTEST\AgentService. Reason: Server is in script upgrade mode. Only administrator can connect at this time.[SQLState 42000]"

Build 10.00.2734 (cumulative update)

This cumulative update package was released on September 21, 2009. The parent build of this build is 10.00.2728. For more information about this build, click the following article number to view the article in the Microsoft Knowledge Base:

973602 Cumulative update package 4 for SQL Server 2008 Service Pack 1

Build 10.00.2728

This build was released on September 6, 2009.The parent build of this build is 10.00.2727.This build contains the following SQL Server 2008 hotfix.

SQL VSTS bug number

Knowledge Base article number

Description

350151

974766

FIX: Error message when you run a parallel query in SQL Server 2008: "Trying to use the transaction while there are 1 parallel nested xacts outstanding"

Build 10.00.2727

This build was released on August 14, 2009.The parent build of this build is 10.00.2723.This build contains the following SQL Server 2008 hotfixes.

SQL VSTS bug number

Knowledge Base article number

Description

340874

972687

FIX: Error message when you restore a SQL Server 2000 database by using SQL Server 2005 Management Studio or SQL Server 2008 Management Studio: "Cannot show requested dialog. Failed to retrieve data for this request (Microsoft.SqlServer.SmoEnum)"

340872

974231

FIX: Some files are not rolled back to the original file versions after you uninstall a SQL Server 2008 Service Pack 1 hotfix that is applied when you use a slipstream installation

Build 10.00.2723 (cumulative update)

This cumulative update package was released on July 20, 2009. The parent build of this build is 10.00.2721. For more information about this build, click the following article number to view the article in the Microsoft Knowledge Base:

971491 Cumulative update package 3 for SQL Server 2008 Service Pack 1

Build 10.00.2721

This build was released on June 25, 2009. The parent build of this build is 10.00.2718.This build contains the following SQL Server 2008 hotfixes.

SQL VSTS bug number

Knowledge Base article number

Description

325091

971136

FIX: Error message when you synchronize a database or manually run sp_replcmds after you perform partial updates on a varbinary(max) column in SQL Server 2008: "The rowset does not contain any column with offset -1."

325086

971985

FIX: A Drillthrough action inside table groups passes incorrect parameter values in SQL Server 2008 Reporting Services

Build 10.00.2718

This build was released on June 12, 2009. The parent build of this build is 10.00.2714. This build contains the following SQL Server 2008 hotfixes.

SQL VSTS bug number

Knowledge Base article number

Description

320616

FIX: The cascading report parameters are inconsistent in a SQL Server 2008 Reporting Services report that contains three or more levels of cascading report parameters

320925

971049

FIX: Error message when you run a SQL Server 2008 Reporting Services report in Business Intelligence Development Studio: "An item with the same key has already been added"

320925

970349

FIX: Queries from a query notification that has a lot of subscriptions run slowly when you change the Auto Close option to False in SQL Server 2005 or in SQL Server 2008

320925

971068

FIX: Error message when you create a SharePoint subscription on a SQL Server 2008 Reporting Services report that uses cascading parameters: "This report requires a default or user-defined value for the report parameter '<Parameter>'"

Build 10.00.2714 (cumulative update)

This cumulative update package was released on May 19, 2009. The parent build of this build is 10.00.2712.For more information about this build, click the following article number to view the article in the Microsoft Knowledge Base:

970315 Cumulative update package 2 for SQL Server 2008 Service Pack 1

Build 10.00.2712

This build was released on May 19, 2009. The parent build of this build is 10.00.2710. This build contains the following SQL Server 2008 hotfix.

SQL VSTS bug number

Knowledge Base article number

Description

311109

970507

FIX: Error message in SQL Server 2008 when you run an INSERT SELECT statement on a table: "Violation of PRIMARY KEY constraint '<PrimaryKey>'. Cannot insert duplicate key in object '<TableName>'"

Build 10.00.2710 (cumulative update)

This cumulative update package was released on April 15, 2009. The parent build of this build is 10.00.2531. For more information about this build, click the following article number to view the article in the Microsoft Knowledge Base:

969099 Cumulative update package 1 for SQL Server 2008 Service Pack 1

Build 10.00.2531 (SQL Server 2008 Service Pack 1)

This is the build of SQL Server 2008 Service Pack 1 that was released on April 7, 2009. For more information about the hotfixes that are included in this service pack, click the following article number to view the article in the Microsoft Knowledge Base:

968369 List of the bugs that are fixed in SQL Server 2008 Service Pack 1

References

For more information about the Incremental Servicing Model for SQL Server, click the following article number to view the article in the Microsoft Knowledge Base:

935897 An Incremental Servicing Model is available from the SQL Server team to deliver hotfixes for reported problemsFor more information about where you can find more information about updates for SQL Server 2005 and for SQL Server 2008, click the following article number to view the article in the Microsoft Knowledge Base:

957826 Where you can find more information about the SQL Server 2008 builds that were released after SQL Server 2008 and about the SQL Server 2005 builds that were released after SQL Server 2005 Service Pack 3 and after SQL Server 2005 Service Pack 2For more information about the naming schema for SQL Server updates, click the following article number to view the article in the Microsoft Knowledge Base:

822499 New naming schema for Microsoft SQL Server software update packages For more information about software update terminology, click the following article number to view the article in the Microsoft Knowledge Base:

824684 Description of the standard terminology that is used to describe Microsoft software updates

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.