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

315550

948567

FIX: When you run a query against a table that contains Traditional Chinese characters, the incorrect result is returned in SQL Server 2005

315552

956574

FIX: Data results are inconsistent when you run a search query that uses the NEAR operator against an XML type data that contains the xml:lang attribute

288894

969142

FIX: Error message when you run the DBCC CHECKDB statement on a database in SQL Server 2005: "Unable to deallocate a kept page"

261045

960090

MS09-004: Description of the security update for SQL Server 2005 QFE: February 10, 2009

271873

962209

FIX: Error message when you run an UPDATE statement on a database that has the SNAPSHOT or READ COMMITTED SNAPSHOT isolation level enabled in SQL Server 2005: "The Database ID <Database ID>, Page (<N>:<N>), slot <N> for LOB data type node does not exist"

269560

961479

FIX: A deadlock may occur when you try to rebuild many indexes in parallel in SQL Server 2005

270367

961648

FIX: You receive an error message when you try to query or update a column of large object (LOB) data in SQL Server 2005

50003708

959132

FIX: Error message when you install Cumulative Update 10 or Cumulative Update 9 for SQL Server 2005 Service Pack 2 on a drive that uses the FAT32 file system: "Unexpected Error Occurred"

50003135

956889

FIX: Error message when you run the snapshot agent on a replication of a stored procedure in SQL Server 2005 or in SQL Server 2008: "The Name property cannot have a value of @param＿name for this version of SQL Server"

50003257

FIX: Error message when SQL Server 2005 synchronizes a mirrored database: "Failed Assertion = 'result == LCK_OK'"

50003258

FIX: You may obtain an incorrect result when you use a cursor to perform DML operations on a table that does not have a clustered index in SQL Server 2008 or in SQL Server 2005

50003481

FIX: An access violation occurs when you display the execution plan for a query that selects a computed column from a remote table in SQL Server 2008 or in SQL Server 2005

50003097

An access violation may occur when you use the bcp.exe utility to copy columns of the NVARCHAR(MAX) data type or of the VARCHAR(MAX) data type in SQL Server 2005

50003080

955997

FIX: You cannot view calculated members in an Excel 2007 pivot table that references an OLAP table in SQL Server 2005 Analysis Services Service Pack 2 or in SQL Server 2008 Analysis Services

50002947

955754

Deadlock occur in SQL Server 2005 when you run an DML statement and an DDL statement at the same time on a partitioned function for the same table

50003019

954950

FIX: Error message when you run a distributed query in SQL Server 2005: "OLE DB provider 'SQLNCLI' for linked server '<Linked Server>' returned message 'No transaction is active'"

50003012

953550

FIX: Error message when you run an MDX query in SQL Server 2005 Analysis Services: "The MDX function failed because the coordinate for the '<AttributeName>' attribute contains a set"

50002988

954669

FIX: An ongoing MS DTC transaction is orphaned in SQL Server 2005

50003005

954831

FIX: In SQL Server 2005, the session that runs the TRUNCATE TABLE statement may stop responding, and you cannot end the session

50003007

954751

FIX: An access violation occurs when you process multiple objects in parallel in SQL Server 2005 Analysis Services

50002912

954054

FIX: Some changes are not replicated to the subscribers when you synchronize data for a transactional replication in SQL Server 2005

50002775

FIX: Error messages may be logged in the SQL Server error log when you use the BULK INSERT statement on a table or you insert data into a table by using Transact-SQL in SQL Server 2005

50002740

952233

FIX: All the MDX queries that are running on an instance of SQL Server 2005 Analysis Services are canceled when you start or stop a SQL Server Profiler trace for the instance

50002776

952330

FIX: The Replication Log Reader Agent may fail intermittently when a transactional replication synchronizes data in SQL Server 2005

50002750

951194

FIX: The hatch patterns are not consistent for all the groups between the legend and the data in a chart in a SQL Server 2005 Reporting Services report

50002748

951190

FIX: The transactional replication does not run the corresponding stored procedure at the subscriber when the stored procedure is run at the publisher in SQL Server 2005

50002765

FIX: Error message when you run an MDX query after you synchronize a SQL Server 2005 Analysis Services database between two instances: "Current session is no longer valid due to structural changes in the database"

50002658

FIX: An access violation occurs when you update a table through a view by using a cursor in SQL Server 2005

50002580

950189

FIX: The SQLGetData function may return zero for the actual size of the data that is to be copied when you use the function to retrieve data for a binary column in SQL Server 2005

50002340

948108

MS08-040: Description of the security update for SQL Server 2005 QFE: July 8, 2008

50002540

949959

FIX: Error message when you synchronize the data of a merge replication in SQL Server 2005: "The merge process is retrying a failed operation made to article 'ArticleName' - Reason: 'Invalid input parameter values. Check the status values for detail.'"

50002512

949595

FIX: Error message when you run a query that uses a join condition in SQL Server 2005: "Non-yielding Scheduler"

50002514

949687

FIX: Error message when you run a transaction from a remote server by using a linked server in SQL Server 2005: "This operation conflicts with another pending operation on this transaction"

50002515

949631

FIX: Error message when you try to create a currency conversion against an Oracle data source in SQL Server 2005 Analysis Services: "The following statement executed when creating named query: SELECT 'Reporting Currency'"

50002473

949199

FIX:Error message when you run queries on a database that has the SNAPSHOT isolation level enabled in SQL Server 2005:"Unable to deallocate a kept page"

50002283

947179

FIX: An MDX query that uses the VisualTotals function returns an incorrect empty value in SQL Server 2005 Analysis Services

50002308

947463

FIX: A stored procedure cannot finish its execution in SQL Server 2005

50002212

947196

FIX: An access violation occurs when you run an MDX query by using a user account that is a member of some different roles in SQL Server 2005 Analysis Services

50002247

945640

FIX: When you use the SUM function in a SCOPE statement in SQL Server 2005 Analysis Services, the SCOPE statement may return an incorrect result

50002248

945641

FIX: A calculation script that calculates the same cells several times may return an incorrect result in SQL Server 2005 Analysis Services Service Pack 2

50002251

947197

FIX: Error message when the workload demand on the server is high in SQL Server 2005 Analysis Services: "Internal error: An unexpected exception occurred"

50002166

945442

FIX: You cannot cancel the query execution immediately if you open a fast forward-only cursor for the query in SQL Server 2005

50002168

945443

FIX: A query takes longer to finish in SQL Server 2005 than in SQL Server 2000 when you open a fast forward-only cursor for the query

50002245

942908

FIX: The change may be undone during the later synchronizations when you change an article on the subscriber in SQL Server 2005

50002246

944358

FIX: Complex script characters appear incorrectly when you display a SQL Server 2005 Reporting Services report in the PDF format

50002249

945916

FIX: Error messages when you delete some records of a table in a transaction or when you update some records of a table in a transaction in SQL Server 2005: "Msg 9002," "Msg 3314," and "Msg 9001"

50002118

Contention occurs on a CMEMTHREAD wait type or on a spinlock.

50002030

A CMEMTHREAD wait type causes high CPU utilization to occur under a load.

50001986

A feature has been added that logs silent conflicts that are caused by divergent metadata.

50001708

In SQL Server Management Studio, you cannot change the password for the db_securityadmin database role if the old password is not specified.

50001999

You cannot return to the original report in Windows Internet Explorer 7 after you open a report that accepts one or more DateTime parameters.

50001951

In SQL Server Management Studio, you cannot change the password for the db_securityadmin database role if the old password is not specified.

50001993

You cannot return to the original report in Internet Explorer 7 after you open a report that accepts one or more DateTime parameters.

50001997

The new batching model that was introduced in SQL Server 2005 SP2 causes an out-of-memory exception when you run the Rebuild Index Task.

50001998

Event ID 17055 messages that an instance of SQL Server 2000 forwards to an instance of SQL Server 2005 are not received by the instance of SQL Server 2005.

50002000 (This bug is a variation of bug number 50000314.)

The Save dialog box in Report Builder stops responding in SQL Server 2005 SP2. This problem occurs if you start Report Builder when a report name is specified in the URL in Report Builder.

50001812

A null reference exception occurs when you set parameters on a Web part that is linked to a document library part.

50001766

942087

A C# application that was built by using SQL Server 2005 Integration Services build 9.00.3042 crashes, and an access violation occurs inDtspipeline.dll.

50001619

An internal exception occurs when you process indexes.

50001625

In SQL Server 2005 Analysis Services Service Pack 2 (SP2), you experience frequent access violations in the PFCompressIterator::DecompressArray function under stress conditions.

50001713

Report Manager drill-down (+/-) does not work consistently with Snapshots.

50001550

Merge non-convergence occurs between the Republisher and the Publisher.

SQL Hotfix bug number

Knowledge Base article number

Description

50001298

938712

In Analysis Services 2005, a full process of a database may not process all the records for some dimensions

50001324

940129

An MDX query may not return results unless "non empty" is specified with the dimension that has unnatural hierarchy

50001440

940128

SQL Server may fail to generate a plan for a complex query that involves cursors and error 8623 occurs

SQL Hotfix bug number

Knowledge Base article number

Description

50001392

939942

FIX: You receive an error message when you try to access a report after you configure SQL Server 2005 Reporting Services to run under the SharePoint integrated mode

SQL Hotfix bug number

Knowledge Base article number

Description

50001482

The TokenAndPermUserStore cache store may continue to grow steadily and decrease performance

50001194

938243

Executing a full-text query against a catalog that is being rebuilt may fail with index corruption errors

SQL Hotfix bug number

Knowledge Base article number

Description

50001193

938086

Running concurrent SQL Server Agent jobs in the context of proxy account may fail with errors

50001352

938086

Running concurrent SQL Server Agent jobs in the context of proxy account may fail with errors

SQL Hotfix bug number

Knowledge Base article number

Description

50001391

939562

A query that contains an INSTEAD OF trigger may fail with error 8624 in SQL Server 2005 SP2

50001367

938363

Non-convergence may occur in merge replication when there are join filters for partition groups and the articles belong to multiple publications

50001379

939285

An incorrect error message may be returned by the SQL Native Client provider when in sync mode and there is a query time-out

50001408

939564

Querying a text column that contains more than 1,024 characters may return incorrect results when you use the SQL Native Client provider

50001397

939563

An UPDATE query or a DELETE query in a Merge Replication topology may fail with error 8152

SQL VSTS bug number

Knowledge Base article number

Description

262044

937745

FIX: You may receive error messages when you try to log in to an instance of SQL Server 2005 and SQL Server handles many concurrent connections

262045

937829

FIX: Error message when you run an MDX query against a database in SQL Server 2005 Service Pack 2: “An unexpected exception occured”

SQL Hotfix bug number

Knowledge Base article number

Description

50001251

937041

FIX: Changes in the publisher database are not replicated to the subscribers in a transactional replication if the publisher database runs exposed in a database mirroring session in SQL Server 2005

50001248

937033

FIX: Error message when you run a linked server query in SQL Server 2005: "The oledbprovider unisys.dmsII.1 for linkserver '<ServerName>' reported an error the provider ran out of memory"

SQL Hotfix bug number

Knowledge Base article number

Description

50001020

936185

FIX: Blocking and performance problems may occur when you enable trace flag 1118 in SQL Server 2005 if the temporary table creation workload is high

50000726

932106

FIX: Error message when you run a DMX query that uses a linked server to query data from an instance of Analysis Services in SQL Server 2005: "The following system error occurred: Logon failure: unknown user name or bad password"

50001024

934734

FIX: A database is marked as suspect when you update a table that contains a non-clustered index in SQL Server 2005

50000924

936863

FIX: Some MDX queries may run slower and consume more memory after you install SQL Server 2005 Analysis Services Service Pack 2

50000925

936262

In SQL Server 2005 Analysis Services, the cache is cleaned even though the memory usage is less than the LowMemoryLimit property that is configured.

50000898

936261

FIX: The process stops responding and the CPU utilization reaches 100 percent when you process a partition in SQL Server 2005 Analysis Services

50000802

932180

FIX: The Cluster Discrimination tab is empty when you browse a clustering model of SQL Server 2005 Analysis Services in SQL Server BIDS

50000920

935341

FIX: Error message when you run an MDX query against a measure in SQL Server 2005 Analysis Services: "An internal error has occurred"

50000732

932331

You receive an error message when you try to build a mining model that contains lots of data on a 32-bit server that is running SQL Server 2005 Analysis Services.

50000890

936254

FIX: An MDX query may be slow if it reads from an aggregation that has less than 4,096 records in SQL Server 2005 Analysis Services

SQL Hotfix bug number

Knowledge Base article number

Description

50001001

932610

FIX: Error message when you run an MDX query in SQL Server 2005 Analysis Services: "An unexpected error occurred (file 'pffilestore.cpp', line 3267, function 'PFFileStore::HandleDataPageFault')"

50001056

935922

FIX: Error message when you install Microsoft Dynamics CRM 3.0: "Setup failed to validate specified Reporting Services Report Server"

50000926

935360

FIX: Error message when you run an MDX query that retrieves data from an Analysis Services database: "An error occurred while the dimension, with the ID of '<DatabaseName>', Name of '<DimensionName>' was being processed"

50000923

935829

FIX: You receive incorrect results when you run an MDX query against a dimension that contains a parent-child hierarchy in SQL Server 2005 Analysis Services

50000871

935830

FIX: A server may start slowly if you have SQL Server 2005 Analysis Services installed and if many objects are stored on the server

50000927

A value from the SQL Server 2005 Analysis Services database may be larger than the value from the source database.

50000899

935831

When you configure proactive caching for a partition in SQL Server 2005 Analysis Services, the underlying partition may be processed two times during a proactive caching update.

50000885

935832

FIX: You cannot cancel an MDX query that runs for a long time in SQL Server 2005 Analysis Services

SQL Hotfix bug number

Knowledge Base article number

Description

50001012

934459

FIX: The Check Database Integrity task and the Execute T-SQL Statement task in a maintenance plan may lose database context in certain circumstances in SQL Server 2005 builds 3150 through 3158

SQL Hotfix bug number

Knowledge Base article number

Description

50000958

934226

FIX: Error message when you try to use Database Mail to send an e-mail message in SQL Server 2005: "profile name is not valid (Microsoft SQL Server, Error 14607)"

SQL Hotfix bug number

Knowledge Base article number

Description

50000900

933549

FIX: You may receive an access violation when you perform a bulk copy operation in SQL Server 2005

50000964

933724

FIX: The query performance is slow when you run a query that uses a user-defined scalar function against an instance of SQL Server 2005

50000875

932115

FIX: The ghost row clean-up thread does not remove ghost rows on some data files of a database in SQL Server 2005

50000969

933766

FIX: Failed assertion message in the Errorlog file when you perform various operations in SQL Server 2005: "Failed Assertion = 'fFalse' Attempt to access expired blob handle (3)"

50000919

When you run an encrypted stored procedure, error 565 may occur. The error message for error 565 is as follows: "A stack overflow occurred in the server while compiling the query. Please simplify the query."

50000918

933808

FIX: Error message when you run a query that contains nested FOR XML clauses in SQL Server 2005: "The XML data type is damaged"

50000921

933499

FIX: Error message when you use transactional replication to replicate the execution of stored procedures to subscribers in SQL Server 2005: "Insufficient memory to run query"

SQL Hotfix bug number

Knowledge Base article number

Description

50000948

934106

FIX: SQL Server 2005 database engine generates failed assertion errors when you use the Replication Monitor to monitor the distribution database

50000952

934188

FIX: The Distribution Agent does not deliver commands to the Subscriber even if the Distribution Agent is running in SQL Server 2005

50000949

934109

FIX: The Distribution Agent generates an access violation when you configure a transactional replication publication to run an additional script after the snapshot is applied at the subscriber in SQL Server 2005

50000960

A content query from the Data Mining Client for Excel add-in may take a long time to display the result set. This problem occurs especially when the result set is large. Microsoft Office Excel may appear to stop responding (hang) when the query is running.

SQL Hotfix bug number

Knowledge Base article number

Description

50000945

933564

FIX: A gradual increase in memory consumption for the USERSTORE_TOKENPERM cache store occurs in SQL Server 2005

261044

960089

MS09-004: Description of the security update for SQL Server 2005 GDR: February 10, 2009

50002995

954606

MS08-052: Description of the security update for GDI+ for SQL Server 2005 Service Pack 2 GDR: September 9, 2008

50002341

948109

MS08-040: Description of the security update for SQL Server 2005 GDR: July 8, 2008

50001012

934458

FIX: The Check Database Integrity task and the Execute T-SQL Statement task in a maintenance plan may lose database context in certain circumstances in SQL Server 2005 builds 3042 through 3053

SQL Hotfix bug number

Knowledge Base article number

Description

50002426

942980

FIX: Error message when you install the release version of SQL Server 2005 on a server that has Windows Internal Database SP2 installed: "The SQL Server service failed to start"

50000919

934246

FIX: Error message when you run a long stored procedure that is encrypted in SQL Server 2005: "A stack overflow occurred in the server while compiling the query"