Build 09.00.3233
This build was released on July 8, 2008.
The parent build of this build is 09.00.3232.
This build contains the following security update for SQL Server 2005.
| SQL Hotfix bug number | Knowledge Base article number | Description |
|---|
| 50002340 | 948108 | MS08-040: Description of the security update for SQL Server 2005 QFE: July 8, 2008 |
Build 09.00.3232
This build was released on March 8, 2008.
The parent build of this build is 09.00.3231.
This build contains the following SQL Server 2005 post-SP2 hotfix.
| SQL Hotfix bug number | Knowledge Base article number | Description |
|---|
| 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.'" |
Build 09.00.3231
This build was released on March 6, 2008.
The parent build of this build is 09.00.3230.
This build contains the following SQL Server 2005 post-SP2 hotfixes.
| SQL Hotfix bug number | Knowledge Base article number | Description |
|---|
| 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'" |
Build 09.00.3230
This build was released on February 28, 2008.
The parent build of this build is 09.00.3228.
This build contains the following SQL Server 2005 post-SP2 hotfix.
| SQL Hotfix bug number | Knowledge Base article number | Description |
|---|
| 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" |
Build 09.00.3228 (cumulative update)
This cumulative update package was released on February 18, 2008.
The parent build of this build is 09.00.3224.
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:
946608 Cumulative update package 6 for SQL Server 2005 Service Pack 2
Build 09.00.3224
This build was released on January 18, 2008.
The parent build of this build is 09.00.3222.
This build contains the following SQL Server 2005 post-SP2 hotfixes.
| SQL Hotfix bug number | Knowledge Base article number | Description |
|---|
| 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 |
Build 09.00.3222
This build was released on January 16, 2008.
The parent build of this build is 09.00.3221.
This build contains the following SQL Server 2005 post-SP2 hotfixes.
| SQL Hotfix bug number | Knowledge Base article number | Description |
|---|
| 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" |
Build 09.00.3221
This build was released on January 2, 2008.
The parent build of this build is 09.00.3215.
This build contains the following SQL Server 2005 post-SP2 hotfixes.
| SQL Hotfix bug number | Knowledge Base article number | Description |
|---|
| 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" |
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.3209.
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 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.3169.
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.3171
This on-demand build was released on May 30, 2007.
The parent build of this build is 09.00.3169.
This build contains the following SQL Server 2005 post-SP2 hotfixes.
| 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” |
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 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 |
Build 09.00.3162
This on-demand build was released on April 23, 2007.
The parent build of this build is 09.00.3161.
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.3159.
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 09.00.3077.
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
Build 09.00.3077
This build was released on February 10, 2009.
The parent build of this build is 09.00.3073.
This build contains the following SQL Server 2005 post-SP2 hotfixes.
| VSTS number | Knowledge Base article number | Description |
|---|
| 261044 | 960089 | MS09-004: Description of the security update for SQL Server 2005 GDR: February 10, 2009 |
Build 09.00.3073
This build was released on September 9, 2008.
The parent build of this build is 09.00.3068.
This build contains the following SQL Server 2005 post-SP2 hotfixes.
| SQL Hotfix bug number | Knowledge Base article number | Description |
|---|
| 50002995 | 954606 | MS08-052: Description of the security update for GDI+ for SQL Server 2005 Service Pack 2 GDR: September 9, 2008 |
Build 09.00.3068
This build was released on July 8, 2008.
The parent build of this build is 09.00.3054.
This build contains the following SQL Server 2005 post-SP2 hotfixes.
| SQL Hotfix bug number | Knowledge Base article number | Description |
|---|
| 50002341 | 948109 | MS08-040: Description of the security update for SQL Server 2005 GDR: July 8, 2008 |
Build 09.00.3054
This build was released on March 4, 2007.
This build contains the following SQL Server 2005 post-SP2 hotfix.
| SQL Hotfix bug number | Knowledge Base article number | Description |
|---|
| 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 |
Build 09.00.3042 (SQL Server 2005 Service Pack 2)
This is the build of SQL Server 2005 Service Pack 2 that was released on February 27, 2007.
This build contains the following SQL Server 2005 hotfixes.
| 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" |