Registrations are now open. Join us today!
There is still a lot of work to do on the wiki yet! More information about editing can be found here.
Already have an account?

Microsoft KB Archive/937137

From BetaArchive Wiki
< Microsoft KB Archive
Revision as of 10:27, 21 July 2020 by X010 (talk | contribs) (Text replacement - ">" to ">")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)

Article ID: 937137

Article Last Modified on 12/19/2007



APPLIES TO

  • Microsoft SQL Server 2005 Standard Edition
  • Microsoft SQL Server 2005 Developer Edition
  • Microsoft SQL Server 2005 Enterprise Edition
  • Microsoft SQL Server 2005 Standard X64 Edition
  • Microsoft SQL Server 2005 Standard Edition for Itanium-based Systems
  • Microsoft SQL Server 2005 Enterprise X64 Edition
  • Microsoft SQL Server 2005 Enterprise Edition for Itanium-based Systems
  • Microsoft SQL Server 2005 Workgroup Edition
  • Microsoft SQL Server 2005 Express Edition
  • Microsoft SQL Server 2005 Express Edition with Advanced Services



INTRODUCTION

This article lists the Microsoft SQL Server 2005 builds that were released after Microsoft SQL Server 2005 Service Pack 2 (SP2) was released.

MORE INFORMATION

Build in progress

This cumulative update package is currently under development.

The parent build of this build will be determined as soon as this build is released.

Build 09.00.3215 (cumulative update)

This cumulative update package was released on December 17, 2007.

The parent build of this build is 09.00.3200.

For more information about the SQL Server 2005 post-Service Pack 2 hotfixes that are included in this build, click the following article number to view the article in the Microsoft Knowledge Base:

943656 Cumulative update package 5 for SQL Server 2005 Service Pack 2


Build 09.00.3209

This on-demand build was released on November 20, 2007.

The parent build of this build is 09.00.3208.

This build contains the following SQL Server 2005 post-SP2 hotfixes.

SQL Hotfix bug number Knowledge Base article number Description
50002118 Contention occurs on a CMEMTHREAD wait type or on a spinlock.

Build 09.00.3208

This on-demand build was released on November 15, 2007.

The parent build of this build is 09.00.3206.

This build contains the following SQL Server 2005 post-SP2 hotfixes.

SQL Hotfix bug number Knowledge Base article number Description
50002030 A CMEMTHREAD wait type causes high CPU utilization to occur under a load.

Build 09.00.3206

This on-demand build was released on November 8, 2007.

The parent build of this build is 09.00.3205.

This build contains the following SQL Server 2005 post-SP2 hotfixes.

SQL Hotfix bug number Knowledge Base article number Description
50001986 A feature has been added that logs silent conflicts that are caused by divergent metadata.

Build 09.00.3205

This on-demand build was released on November 7, 2007.

The parent build of this build is 09.00.3203.

This build contains the following SQL Server 2005 post-SP2 hotfixes.

SQL Hotfix bug number Knowledge Base article number Description
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.

Build 09.00.3203

This on-demand build was released on September 30, 2007.

The parent build of this build is 09.00.3200.

This build contains the following SQL Server 2005 post-SP2 hotfixes.

SQL Hotfix bug number Knowledge Base article number Description
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.

Build 09.00.3200 (cumulative update)

This cumulative update package was released on October 15, 2007.

The parent build of this build is 09.00.3195.

For more information about the SQL Server 2005 post-Service Pack 2 hotfixes that are included in this build, click the following article number to view the article in the Microsoft Knowledge Base:

941450 Cumulative update package 4 for SQL Server 2005 Service Pack 2


Build 09.00.3195

This on-demand build was released on September 19, 2007.

The parent build of this build is 09.00.3194.

This build contains the following SQL Server 2005 post-SP2 hotfixes.

SQL Hotfix bug number Knowledge Base article number Description
50001812 A null reference exception occurs when you set parameters on a Web part that is linked to a document library part.

Build 09.00.3194

This on-demand build was released on September 11, 2007.

The parent build of this build is 09.00.3186.

This build contains the following SQL Server 2005 post-SP2 hotfixes.

SQL Hotfix bug number Knowledge Base article number Description
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 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.

Build 09.00.3186 (cumulative update)

This cumulative update package was released on August 20, 2007.

The parent build of this build is 09.00.3182.

For more information about the SQL Server 2005 post-Service Pack 2 hotfixes that are included in this build, click the following article number to view the article in the Microsoft Knowledge Base:

939537 Cumulative update package 3 for SQL Server 2005 Service Pack 2


Build 09.00.3182

This build is no longer available. Please use build 3186 or higher. This on-demand build was released on July 17, 2007.

The parent build of this build is 09.00.3180.

This build contains the following SQL Server 2005 post-SP2 hotfixes.

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

Build 09.00.3180

This build is no longer available. Please use build 3186 or higher. This on-demand build was released on July 11, 2007.

The parent build of this build is 09.00.3179.

This build contains the following SQL Server 2005 post-SP2 hotfixes.

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

Build 09.00.3179

This build is no longer available. Please use build 3186 or higher. This on-demand build was released on July 11, 2007.

The parent build of this build is 09.00.3178.

This build contains the following SQL Server 2005 post-SP2 hotfixes.

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

Build 09.00.3178

This build is no longer available. Please use build 3186 or higher. This on-demand build was released on July 5, 2007.

The parent build of this build is 09.00.3177.

This build contains the following SQL Server 2005 post-SP2 hotfixes.

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

Build 09.00.3177

This build is no longer available. Please use build 3186 or higher. This on-demand build was released on June 29, 2007.

The parent build of this build is 09.00.3175.

This build contains the following SQL Server 2005 post-SP2 hotfixes.

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

Build 09.00.3175 (cumulative update)

This cumulative update package was released on June 18, 2007.

The parent build of this build is 09.00.3166. For more information about the SQL Server 2005 post-Service Pack 2 hotfixes that are included in this build, click the following article number to view the article in the Microsoft Knowledge Base:

936305 Cumulative update package 2 for SQL Server 2005 Service Pack 2 is available


Build 09.00.3169

This on-demand build was released on May 18, 2007.

The parent build of this build is 09.00.3166.

This build contains the following SQL Server 2005 post-SP2 hotfixes.

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"

Build 09.00.3166

This on-demand build was released on May 7, 2007.

The parent build of this build is 09.00.3162.

This build contains the following SQL Server 2005 post-SP2 hotfixes.

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 nonclustered 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

Build 09.00.3162

This on-demand build was released on April 23, 2007.

The parent build of this build is 09.00.3156.

This build contains the following SQL Server 2005 post-SP2 hotfixes.

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

Build 09.00.3161 (cumulative update)

This cumulative update package was released on April 16, 2007.

The parent build of this build is 09.00.3156.

For more information about the SQL Server 2005 post-Service Pack 2 hotfixes that are included in this build, click the following article number to view the article in the Microsoft Knowledge Base:

935356 Cumulative update package (build 3161) for SQL Server 2005 Service Pack 2 is available


Build 09.00.3159

This on-demand build was released on April 4, 2007.

The parent build of this build is 09.00.3156.

This build contains the following SQL Server 2005 post-SP2 hotfix.

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

Build 09.00.3156

This cumulative update package was released on March 23, 2007.

The parent build of this build is 09.00.3155.

This build contains the following SQL Server 2005 post-SP2 hotfix.

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)"

Build 09.00.3155

This on-demand build was released on March 21, 2007.

The parent build of this build is 09.00.3154.

This build contains the following SQL Server 2005 post-SP2 hotfixes.

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"

Build 09.00.3154

This on-demand build was released on March 21, 2007.

The parent build of this build is 09.00.3153.

This build contains the following SQL Server 2005 post-SP2 hotfixes.

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.

Build 09.00.3153

This on-demand build was released on March 15, 2007.

The parent build of this build is 09.00.3152.

This build contains the following SQL Server 2005 post-SP2 hotfix.

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

Build 09.00.3152

This cumulative hotfix package was released on March 15, 2007.

The parent build of this build is SQL Server 2005 SP2 (09.00.3042).

For more information about the SQL Server 2005 post-Service Pack 2 hotfixes that are included in this build, click the following article number to view the article in the Microsoft Knowledge Base:

933097 Cumulative hotfix package (build 3152) for SQL Server 2005 Service Pack 2 is available


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 how to obtain SQL Server 2005 Service Pack 2, click the following article number to view the article in the Microsoft Knowledge Base:

913089 How to obtain the latest service pack for SQL Server 2005


For more information about the new features and the improvements in SQL Server 2005 Service Pack 2, visit the following Microsoft Web site:

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


Keywords: kbhowto kbinfo KB937137