INTRODUCTION

Microsoft SQL Server 2008 hotfixes are created for specific SQL Server service packs. You must apply a SQL Server 2008 Service Pack 2 hotfix to an installation of SQL Server 2008 Service Pack 2. By default, any hotfix that is provided in a SQL Server service pack is included in the next SQL Server service pack. Cumulative update 1 for SQL Server 2008 Service Pack 2 (SP2) is intended as a post-service pack rollup for SQL Server 2008 customers who plan to upgrade to SQL Server 2008 SP2 and still keep the hotfixes from SQL Server 2008 SP1Cumulative Update 9 to SQL Server 2008 SP1Cumulative Update 10.Note This build of the cumulative update package is also known as build 10.00.4266.00. We recommend that you test hotfixes before you deploy them in a production environment. Because the builds are cumulative, each new fix release contains all the hotfixes and all the security fixes that were included with the previous SQL Server 2008 fix release. We recommend that you consider applying the most recent fix release that contains this hotfix. For more information, click the following article number to view the article in the Microsoft Knowledge Base:

2402659 The SQL Server 2008 builds that were released after SQL Server 2008 Service Pack 2 was released

Important notes about the cumulative update package

  • SQL Server 2008 hotfixes are now multilanguage. Therefore, there is only one cumulative hotfix package for all languages.

  • One cumulative hotfix package includes all the component packages. The cumulative update package updates only those components that are installed on the system.

More Information

How to obtain Cumulative Update 1 for SQL Server 2008 Service Pack 2

A supported cumulative update package is now available from Microsoft. However, it is intended to correct only the problems that are described in this article. Apply it only to systems that are experiencing these specific problems. This cumulative update package may receive additional testing. Therefore, if you are not severely affected by any of these problems, we recommend that you wait for the next SQL Server 2008 service pack that contains the hotfixes in this cumulative update package. If the cumulative update is available for download, there is a "Hotfix download available" section at the top of this Knowledge Base article. If this section does not appear, contact Microsoft Customer Service and Support to obtain the cumulative update package. Note If additional issues occur or any troubleshooting is required, you might have to create a separate service request. The usual support costs will apply to additional support questions and issues that do not qualify for this specific cumulative update package. For a complete list of Microsoft Customer Service and Support telephone numbers or to create a separate service request, visit the following Microsoft website:

http://support.microsoft.com/contactus/?ws=supportNote The "Hotfix Download Available" form displays the languages for which the cumulative update is available. If you do not see your language, it is because a cumulative update package is not available for that language.

Hotfixes that are included in Cumulative Update 1 for SQL Server 2008 Service Pack 2

Microsoft Knowledge Base articles that discuss these hotfixes will be released as they become available. For more information about the SQL Server bugs, click the following article numbers to view the articles in the Microsoft Knowledge Base:

VSTS bug number

KB article number

Description

561807

942712

FIX: The W3WP.exe process of Internet Information Services stops unexpectedly when you configure a merge replication that uses Web synchronization in SQL Server 2005 and SQL Server 2008

549033

none

CDC capture job can experience the following assert condition when you have CDC enabled on database tables which have XML or other blob datatype columns:Assertion: File: <file name>line=<line number> Failed Assertion = 'fNoWriters' -AND- line=<line number> Failed Assertion = 'fNoReaderWriterConflict'

576988

979212

FIX: A DateTime value is replaced by a NULL value when a conflict is resolved by using a custom resolver in Microsoft SQL Server 2005, Microsoft SQL Server 2008 or Microsoft SQL Server 2008 R2 merge replication

576899

980142

FIX: You receive a "Provider Load Failure" error message or the Wmiprvse.exe process stops responding when you use a SQL Server WMI provider to obtain information about SQL Server 2005, SQL Server 2008, or SQL Server 2008 R2 services

548967

980350

FIX: Polish word breaker causes a Full-Text query to return an incomplete result in SQL Server 2008

548983

980570

FIX: "Fulltext index error during compression or decompression" error message when you rebuild the full-text search index in Microsoft SQL Server 2008 or in Microsoft SQL Server 2008 R2

548985

980832

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

576971

980849

FIX: You experience high latency for peer-to-peer distribution agents in Microsoft SQL Server 2005, Microsoft SQL Server 2008, or Microsoft SQL Server 2008 R2

548999

980883

FIX: Proactive caching starts unexpectedly when you insert data in SQL Server 2005, SQL Server 2008 R2 or SQL Server 2008

576984

980948

FIX: Metadata is corrupted when you move SSAS 2005, SSAS 2008 R2 or SSAS 2008 data folders from one computer to another computer

548987

981120

FIX: Error message when you enable TDE on a database that has the snapshot isolation enabled in SQL Server 2008 or in SQL Server 2008 R2

549015

981502

FIX: A query that uses a parallel query plan returns different results every time that you run the query in SQL Server 2005, SQL Server 2008 R2 or SQL Server 2008

576985

981713

FIX: A query returns an incorrect result if it uses an index that is being rebuilt online in SQL Server 2005, SQL Server 2008 R2 or SQL Server 2008

576992

981867

FIX: A calculated member that uses filtered dimension members returns an incorrect result in SSAS 2005, SSAS 2008 R2 or SSAS 2008

576993

981888

FIX: "Deadlock monitor failed to resolve this deadlock. Server may require restart to recover from this condition" error message when a database is being recovered in Microsoft SQL Server 2005, Microsoft SQL Server 2008, or Microsoft SQL Server 2008 R2

548989

982034

FIX: The translation feature does not work when you perform a grouping action in an Excel PivotTable that uses SSAS 2008 or SSAS 2008 R2 as the data source

577024

982363

FIX: SQL Server 2005, SQL Server 2008, or SQL Server 2008 R2 may require a long time to complete an ALTER TABLE statement that alters an XML data type column from "NOT NULL" to "NULL" in a table

576999

982376

FIX: A non-yielding scheduler error or an error 8623 occurs when you run a query that contains a large IN clause in SQL Server 2005, SQL Server 2008, or SQL Server 2008 R2

561817

982808

A drillthrough report may not work incorrectly correctly if the "Prompt for credentials" option is used in the data sources in SQL Server 2008 Reporting Service

548995

982854

FIX: "There is insufficient system memory in resource pool 'internal' to run this query" error message when you run a full-text query that uses compound words in Microsoft SQL Server 2008 or in Microsoft SQL Server 2008 R2

548997

982857

FIX: Error message when you configure a transactional replication for a database in SQL Server 2008 or in SQL Server 2008 R2

577003

982932

Query Performance decreases after you apply SQL Server 2005 SP2 Cumulative Update 7 or a later version

577002

983429

FIX: A deadlock occurs when you run a query or a stored procedure that contains an XML column in SQL Server 2005, SQL Server 2008, or SQL Server 2008 R2

549007

983446

A SSRS 2008 report shows duplicate first row for each group of a subreport when you export the report to CSV format

577006

983480

FIX: Various issues occur when a database is involved in a database mirroring session and in a transactional replication if trace flag 1448 is enabled

577007

983500

FIX: The role synchronization process is delayed when a mirroring automatic failover occurs in SQL Server 2005, SQL Server 2008, or SQL Server 2008 R2

549013

983577

FIX: The export process never finishes when you export a report that has nested tablix items in SSRS 2008 or in SSRS 2008 R2 to the extensions that are supported by the hard page-break renderers

442541

2022254

SQL Server may report 18272 error during restore operations

549017

2028406

FIX: Blank spaces between some items are generated incorrectly in a SQL Server 2008 or a SQL Server 2008 R2 report

561732

2028727

FIX: Column group values are displayed in only the last child row group of the adjacent row groups in SSRS 2008

549020

2028755

FIX: An incorrect result is returned when you run a LIKE query with wildcards and the Latin1_General_100_CS_AS collation in Microsoft SQL Server 2008 or in Microsoft SQL Server 2008 R2

561809

2028830

FIX: Shared components are installed in the wrong location when you implement a SQL Server 2008 Failover Cluster installation

561744

2121407

FIX: Error message when you use the sqlcmd utility to execute the Transact-SQL query in SQL Server 2008 and SQL Server 2008 R2

549026

2152148

FIX: "Internal error: An unexpected exception occurred" error message when you run a Multidimensional Expressions (MDX) query by using time intelligence in Microsoft SQL Server Analysis Services 2008

549039

2200755

FIX: Error message when you run a MDX query in SSAS 2008 or in SSAS 2008 R2

561746

2214666

FIX: An SSIS package that uses the Unpivot transformation may produce inconsistent results in SQL Server 2008

549041

2220252

FIX: A SQL Server 2005 report that uses the visibility toggles feature runs incorrectly in SQL Server 2008 or in SQL Server 2008 R2

577012

2222998

FIX: An incorrect cardinality estimate is returned when you run a query in SQL Server 2005, SQL Server 2008, or SQL Server 2008 R2

549031

2248999

FIX: An index corruption occurs when you update a view in Microsoft SQL Server 2008 or in Microsoft SQL Server 2008 R2

549043

2255410

A query returns inconsistent results before the data cache is warmed up in SSAS 2008 or in SSAS 2008 R2

561750

2256829

FIX: A certain number of the last XML columns may not be replicated correctly if you use web synchronization for merge replication in SQL Server 2008

561757

2260502

FIX: Query performance decreases after you upgrade to SQL Server 2008 from SQL Server 2000 if the query uses a user-defined scalar function

561760

2261403

FIX: The "SQL Server:SSIS Pipeline 10.0" performance object does not appear in the "Performance object" list while another user accesses some SSIS pipeline counters in SQL Server 2008 or in SQL Server 2008 R2

549028

2264562

FIX: A full-text query that uses CONTAINS or FREETEXT predicate together with the "OR" operator takes a long time to run in SQL Server 2008 or in in SQL Server 2008 R2

577013

2268122

FIX: "User 'guest' does not have permission to run DBCC checkdb for database 'mssqlsystemresource'" error message when you run the DBCC CHECKDB('master') command on a computer that is running SQL Server 2005, SQL Server 2008, or SQL Server 2008 R2

561766

2276330

FIX: The "CHANGETABLE" function is slow in SQL Server 2008 and in SQL Server 2008 R2

561768

2276717

FIX: Error code 1456 when you add a witness to a new database mirroring session that has the same database name as an existing database mirroring session in Microsoft SQL Server 2005, Microsoft SQL Server 2008, and Microsoft SQL Server 2008 R2

577014

2277207

FIX: The value of the "Axis" label appears in each column and the "Gridline Interval" value is not honored after a RDL file is upgraded from SSRS 2005 to SSRS 2008

561770

2278042

FIX: A derived column transformation may generate incorrect results in SSIS 2008 or in SSIS 2008 R2 when a column is derived both in read-only usage and in read/write usage

561773

2282743

FIX: The special characters are displayed incorrectly in a "TextBox" control of a PDF file when you render a report in SSRS 2008

577017

2283072

FIX: A hotfix is available that enables SQL Server 2008 Reporting Services and SQL Server 2008 R2 Reporting Services to use a 2048-bit RSA key to encrypt a Reporting Services key for FIPS compliancy

561791

2287990

FIX: The "Derived Column" transformation may produce incorrect results when you run a package in Microsoft SQL Server 2008 Integration Services

561789

2292725

FIX: You experience decreased performance when you run an MDX query in SQL Server 2008 SP1 that has cumulative update 5 or a later version of the update package installed

577020

2297308

FIX: "A previous filestream configuration attempt was incomplete" error and an access violation occur when you perform post-setup configuration of the FILESTREAM feature on a SQL Server 2008 or SQL Server 2008 R2 failover cluster

561783

2297709

FIX: An error message may occur when you run a "BULK INSERT" query on a database that uses the "BULK_LOGGED" or "SIMPLE" recovery model in SQL Server 2008

577018

2297903

FIX: Event ID 322 is logged when a server audit is output in SQL Server 2008 or SQL Server 2008 R2

561801

2300689

FIX: You cannot restore a backup of a database on another instance of SQL Server if you disable transparent data encryption before you create the backup in SQL Server 2008 or in SQL Server 2008 R2

561787

2306162

FIX: Poor performance and some occasional non-yielding scheduler errors occur when you create a complex view that references a large amount of nested views or tables in SQL Server 2008

561785

2316135

FIX: "An unexpected exception occurred" internal error and heap corruption occurs when you run a MDX query that is generated by third-party software in SSAS 2008

561793

2344600

FIX: "Non-yielding Scheduler" error may occur when you use the CONTAINSTABLE function together with many OR and AND predicates in SQL Server 2008

561795

2352413

FIX: Query failure and an "Invalid column name" error message occur when you run a linked server query to another instance of SQL Server 2008

561742

2379466

FIX: "0x84B10001" error code, SQL Server 2008 Setup failure, and an unhandled exception occur when you run SQL Server 2008 Setup

561797

2380361

FIX: Error message when you run the "sp_createstats" stored procedure in SQL Server 2008 or in SQL Server 2008 R2 if the table contains a nondeterministic computed column

561799

2380435

FIX: The query plan for a stored procedure is not cached if the stored procedure uses a BLOB variable and the variable is used in a string function in Microsoft SQL Server 2008 or in Microsoft SQL Server 2008 R2

561803

2384766

FIX: The ANSI_NULLS property of an indexed view is changed to FALSE after the indexed view is replicated to the subscription database in SQL Server 2008 or in SQL Server 2008 R2

561805

2387686

FIX: "A MOF syntax error occurred" error message occurs when you try to install SQL Server 2008 or SQL Server 2008 R2

561813

2399715

FIX: An "UPDATE CUBE" statement returns an incorrect error message when you try to update a calculated measure or a calculated member in SSAS 2008

561811

2407172

FIX: An exception occurs before the error output for invalid data of an "XML Source" task is redirected in SSIS 2005 or SSIS 2008

Cumulative update package information

Prerequisites

Microsoft SQL Server 2008 Service Pack 2 For more information, click the following article number to view the article in the Microsoft Knowledge Base:

968382 How to obtain the latest service pack for SQL Server 2008

Restart information

You may have to restart the computer after you apply this cumulative update package.

Registry information

To use one of the hotfixes in this package, you do not have to make any changes to the registry.

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 problems For 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.