United States

Change

All Microsoft Sites

Microsoft Support

Article ID: 937137 - Last Review: August 17, 2009 - Revision: 27.1

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

View products that this article applies to.

INTRODUCTION

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

Back to the top

This cumulative update package was released on October 19, 2009.

The parent build of this build is 09.00.3330.
For more information about this build, click the following article number to view the article in the Microsoft Knowledge Base:

974647 (http://support.microsoft.com/kb/974647/ ) Cumulative update package 16 for SQL Server 2005 Service Pack 2

Back to the top

Build 09.00.3330 (cumulative update)

This cumulative update package was released on August 17, 2009.

The parent build of this build is 09.00.3328.
For more information about this build, click the following article number to view the article in the Microsoft Knowledge Base:

972510 (http://support.microsoft.com/kb/972510/ ) Cumulative update package 15 for SQL Server 2005 Service Pack 2

Back to the top

Build 09.00.3328 (cumulative update)

This cumulative update package was released on June 15, 2009.

The parent build of this build is 09.00.3327.
For more information about this build, click the following article number to view the article in the Microsoft Knowledge Base:

970278 (http://support.microsoft.com/kb/970278/ ) Cumulative update package 14 for SQL Server 2005 Service Pack 2

Back to the top

Build 09.00.3327

This build was released on May 26, 2009.

The parent build of this build is 09.00.3325.

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

Collapse this tableExpand this table

VSTS bug number	Knowledge Base article number	Description
315550	948567 (http://support.microsoft.com/kb/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 (http://support.microsoft.com/kb/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

Back to the top

Build 09.00.3325 (cumulative update)

This cumulative update package was released on April 20, 2009.

The parent build of this build is 09.00.3322.
For more information about this build, click the following article number to view the article in the Microsoft Knowledge Base:

967908 (http://support.microsoft.com/kb/967908/ ) Cumulative update package 13 for SQL Server 2005 Service Pack 2

Back to the top

Build 09.00.3320

This build was released on March 17, 2009.

The parent build of this build is 09.00.3315.

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

Collapse this tableExpand this table

VSTS bug number	Knowledge Base article number	Description
288894	969142 (http://support.microsoft.com/kb/969142/ )	FIX: Error message when you run the DBCC CHECKDB statement on a database in SQL Server 2005: "Unable to deallocate a kept page"

Back to the top

Build 09.00.3315 (cumulative update)

This cumulative update package was released on February 16, 2009.

The parent build of this build is 09.00.3310.
For more information about this build, click the following article number to view the article in the Microsoft Knowledge Base:

962970 (http://support.microsoft.com/kb/962970/ ) Cumulative update package 12 for SQL Server 2005 Service Pack 2

Back to the top

Build 09.00.3310

This build was released on February 10, 2009.

The parent build of this build is 09.00.3303.

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

Collapse this tableExpand this table

VSTS bug number	Knowledge Base article number	Description
261045	960090 (http://support.microsoft.com/kb/960090/ )	MS09-004: Description of the security update for SQL Server 2005 QFE: February 10, 2009

Back to the top

Build 09.00.3303

This build was released on February 10, 2009.

The parent build of this build is 09.00.3302.

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

Collapse this tableExpand this table

VSTS bug number	Knowledge Base article number	Description
271873	962209 (http://support.microsoft.com/kb/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"

Back to the top

Build 09.00.3302

This build was released on January 13, 2009.

The parent build of this build is 09.00.3301.

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

Collapse this tableExpand this table

VSTS bug number	Knowledge Base article number	Description
269560	961479 (http://support.microsoft.com/kb/961479/ )	FIX: A deadlock may occur when you try to rebuild many indexes in parallel in SQL Server 2005
270367	961648 (http://support.microsoft.com/kb/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

Back to the top

Build 09.00.3301 (cumulative update)

This cumulative update package was released on December 15, 2008.

The parent build of this build is 09.00.3295.
For more information about this build, click the following article number to view the article in the Microsoft Knowledge Base:

958735 (http://support.microsoft.com/kb/958735/ ) Cumulative update package 11 for SQL Server 2005 Service Pack 2

Back to the top

Build 09.00.3295

This build was released on November 3, 2008.

The parent build of this build is 09.00.3294.

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

Collapse this tableExpand this table

SQL Hotfix bug number	Knowledge Base article number	Description
50003708	959132 (http://support.microsoft.com/kb/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"

Back to the top

Build 09.00.3294 (cumulative update)

This cumulative update package was released on October 20, 2008.

The parent build of this build is 09.00.3291.
For more information about this build, click the following article number to view the article in the Microsoft Knowledge Base:

956854 (http://support.microsoft.com/kb/956854/ ) Cumulative update package 10 for SQL Server 2005 Service Pack 2

Back to the top

Build 09.00.3291

This build was released on September 26, 2008.

The parent build of this build is 09.00.3289.

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

Collapse this tableExpand this table

SQL Hotfix bug number	Knowledge Base article number	Description
50003135	956889 (http://support.microsoft.com/kb/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"

Back to the top

Build 09.00.3289

This build was released on September 18, 2008.

The parent build of this build is 09.00.3282.

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

Collapse this tableExpand this table

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

Back to the top

Build 09.00.3282 (cumulative update)

This cumulative update package was released on Aug 18, 2008.

The parent build of this build is 09.00.3263.

For more information about this build, click the following article number to view the article in the Microsoft Knowledge Base:

953752 (http://support.microsoft.com/kb/953752/ ) Cumulative update package 9 for SQL Server 2005 Service Pack 2

Back to the top

Build 09.00.3263

This build was released on July 30, 2008.

The parent build of this build is 09.00.3262

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

Collapse this tableExpand this table

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

Back to the top

Build 09.00.3262

This build was released on July 26, 2008.

The parent build of this build is 09.00.3261.

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

Collapse this tableExpand this table

SQL Hotfix bug number	Knowledge Base article number	Description
50003080	955997 (http://support.microsoft.com/kb/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

Back to the top

Build 09.00.3261

This build was released on July 31, 2008.

The parent build of this build is 09.00.3260.

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

Collapse this tableExpand this table

SQL Hotfix bug number	Knowledge Base article number	Description
50002947	955754 (http://support.microsoft.com/kb/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

Back to the top

Build 09.00.3260

This build was released on July 3, 2008.

The parent build of this build is 09.00.3259.

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

Collapse this tableExpand this table

SQL Hotfix bug number	Knowledge Base article number	Description
50003019	954950 (http://support.microsoft.com/kb/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'"

Back to the top

Build 09.00.3259

This build was released on July 1, 2008.

The parent build of this build is 09.00.3257.

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

Collapse this tableExpand this table

SQL Hotfix bug number	Knowledge Base article number	Description
50003012	953550 (http://support.microsoft.com/kb/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 (http://support.microsoft.com/kb/954669/ )	FIX: An ongoing MS DTC transaction is orphaned in SQL Server 2005
50003005		FIX: In SQL Server 2005, the session that runs the TRUNCATE TABLE statement may stop responding, and you cannot end the session
50003007		FIX: An access violation occurs when you process multiple objects in parallel in SQL Server 2005 Analysis Services

Back to the top

Build 09.00.3257 (cumulative update)

This cumulative update package was released on June 16, 2008.

The parent build of this build is 09.00.3253.

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:

951217 (http://support.microsoft.com/kb/951217/ ) Cumulative update package 8 for SQL Server 2005 Service Pack 2

Back to the top

Build 09.00.3253

This build was released on June 19, 2008.

The parent build of this build is 09.00.3248.

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

Collapse this tableExpand this table

SQL Hotfix bug number	Knowledge Base article number	Description
50002912	954054 (http://support.microsoft.com/kb/954054/ )	FIX: Some changes are not replicated to the subscribers when you synchronize data for a transactional replication in SQL Server 2005

Back to the top

Build 09.00.3248

This build was released on May 22, 2008.

The parent build of this build is 09.00.3246.

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

Collapse this tableExpand this table

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

Back to the top

Build 09.00.3246

This build was released on May 13, 2008.

The parent build of this build is 09.00.3244.

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

Collapse this tableExpand this table

SQL Hotfix bug number	Knowledge Base article number	Description
50002740	952233 (http://support.microsoft.com/kb/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

Back to the top

Build 09.00.3244

This build was released on May 6, 2008.

The parent build of this build is 09.00.3242.

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

Collapse this tableExpand this table

SQL Hotfix bug number	Knowledge Base article number	Description
50002776	952330 (http://support.microsoft.com/kb/952330/ )	FIX: The Replication Log Reader Agent may fail intermittently when a transactional replication synchronizes data in SQL Server 2005

Back to the top

Build 09.00.3242

This build was released on April 29, 2008.

The parent build of this build is 09.00.3240.

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

Collapse this tableExpand this table

SQL Hotfix bug number	Knowledge Base article number	Description
50002750	951194 (http://support.microsoft.com/kb/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 (http://support.microsoft.com/kb/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"

Back to the top

Build 09.00.3240

This build was released on April 23, 2008.

The parent build of this build is 09.00.3239.

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

Collapse this tableExpand this table

SQL Hotfix bug number	Knowledge Base article number	Description
50002658		FIX: An access violation occurs when you update a table through a view by using a cursor in SQL Server 2005

Back to the top

Build 09.00.3239 (cumulative update)

This cumulative update package was released on April 14, 2008.

The parent build of this build is 09.00.3235.

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:

949095 (http://support.microsoft.com/kb/949095/ ) Cumulative update package 7 for SQL Server 2005 Service Pack 2

Back to the top

Build 09.00.3235

This build was released on March 19, 2008.

The parent build of this build is 09.00.3233.

This build contains the following SQL Native Client hotfix.

Collapse this tableExpand this table

SQL Hotfix bug number	Knowledge Base article number	Description
50002580	950189 (http://support.microsoft.com/kb/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

Back to the top

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.

Collapse this tableExpand this table

SQL Hotfix bug number	Knowledge Base article number	Description
50002340	948108 (http://support.microsoft.com/kb/948108/ )	MS08-040: Description of the security update for SQL Server 2005 QFE: July 8, 2008

Back to the top

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.

Collapse this tableExpand this table

SQL Hotfix bug number	Knowledge Base article number	Description
50002540	949959 (http://support.microsoft.com/kb/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.'"

Back to the top

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.

Collapse this tableExpand this table

SQL Hotfix bug number	Knowledge Base article number	Description
50002512	949595 (http://support.microsoft.com/kb/949595/ )	FIX: Error message when you run a query that uses a join condition in SQL Server 2005: "Non-yielding Scheduler"
50002514	949687 (http://support.microsoft.com/kb/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 (http://support.microsoft.com/kb/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'"

Back to the top

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.

Collapse this tableExpand this table

SQL Hotfix bug number	Knowledge Base article number	Description
50002473	949199 (http://support.microsoft.com/kb/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"

Back to the top

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 (http://support.microsoft.com/kb/946608/ ) Cumulative update package 6 for SQL Server 2005 Service Pack 2

Back to the top

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.

Collapse this tableExpand this table

SQL Hotfix bug number	Knowledge Base article number	Description
50002283	947179 (http://support.microsoft.com/kb/947179/ )	FIX: An MDX query that uses the VisualTotals function returns an incorrect empty value in SQL Server 2005 Analysis Services
50002308	947463 (http://support.microsoft.com/kb/947463/ )	FIX: A stored procedure cannot finish its execution in SQL Server 2005

Back to the top

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.

Collapse this tableExpand this table

SQL Hotfix bug number	Knowledge Base article number	Description
50002212	947196 (http://support.microsoft.com/kb/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 (http://support.microsoft.com/kb/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 (http://support.microsoft.com/kb/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 (http://support.microsoft.com/kb/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"

Back to the top

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.

Collapse this tableExpand this table

SQL Hotfix bug number	Knowledge Base article number	Description
50002166	945442 (http://support.microsoft.com/kb/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 (http://support.microsoft.com/kb/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 (http://support.microsoft.com/kb/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 (http://support.microsoft.com/kb/944358/ )	FIX: Complex script characters appear incorrectly when you display a SQL Server 2005 Reporting Services report in the PDF format
50002249	945916 (http://support.microsoft.com/kb/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"

Back to the top

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 (http://support.microsoft.com/kb/943656/ ) Cumulative update package 5 for SQL Server 2005 Service Pack 2

Back to the top

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.

Collapse this tableExpand this table

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

Back to the top

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.

Collapse this tableExpand this table

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

Back to the top

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.

Collapse this tableExpand this table

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.

Back to the top

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.

Collapse this tableExpand this table

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.

Back to the top

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.

Collapse this tableExpand this table

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.

Back to the top

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 (http://support.microsoft.com/kb/941450/ ) Cumulative update package 4 for SQL Server 2005 Service Pack 2

Back to the top

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.

Collapse this tableExpand this table

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.

Back to the top

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.

Collapse this tableExpand this table

SQL Hotfix bug number	Knowledge Base article number	Description
50001766	942087 (http://support.microsoft.com/kb/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.

Back to the top

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 (http://support.microsoft.com/kb/939537/ ) Cumulative update package 3 for SQL Server 2005 Service Pack 2

Back to the top

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.

Collapse this tableExpand this table

SQL Hotfix bug number	Knowledge Base article number	Description
50001298	938712 (http://support.microsoft.com/kb/938712/ )	In Analysis Services 2005, a full process of a database may not process all the records for some dimensions
50001324	940129 (http://support.microsoft.com/kb/940129/ )	An MDX query may not return results unless "non empty" is specified with the dimension that has unnatural hierarchy
50001440	940128 (http://support.microsoft.com/kb/940128/ )	SQL Server may fail to generate a plan for a complex query that involves cursors and error 8623 occurs

Back to the top

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.

Collapse this tableExpand this table

SQL Hotfix bug number	Knowledge Base article number	Description
50001392	939942 (http://support.microsoft.com/kb/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

Back to the top

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.

Collapse this tableExpand this table

SQL Hotfix bug number	Knowledge Base article number	Description
50001482		The TokenAndPermUserStore cache store may continue to grow steadily and decrease performance
50001194	938243 (http://support.microsoft.com/kb/938243/ )	Executing a full-text query against a catalog that is being rebuilt may fail with index corruption errors

Back to the top

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.

Collapse this tableExpand this table

SQL Hotfix bug number	Knowledge Base article number	Description
50001193	938086 (http://support.microsoft.com/kb/938086/ )	Running concurrent SQL Server Agent jobs in the context of proxy account may fail with errors
50001352	938086 (http://support.microsoft.com/kb/938086/ )	Running concurrent SQL Server Agent jobs in the context of proxy account may fail with errors

Back to the top

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.

Collapse this tableExpand this table

SQL Hotfix bug number	Knowledge Base article number	Description
50001391	939562 (http://support.microsoft.com/kb/939562/ )	A query that contains an INSTEAD OF trigger may fail with error 8624 in SQL Server 2005 SP2
50001367	938363 (http://support.microsoft.com/kb/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 (http://support.microsoft.com/kb/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 (http://support.microsoft.com/kb/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 (http://support.microsoft.com/kb/939563/ )	An UPDATE query or a DELETE query in a Merge Replication topology may fail with error 8152

Back to the top

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 (http://support.microsoft.com/kb/936305/ ) Cumulative update package 2 for SQL Server 2005 Service Pack 2 is available

Back to the top

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.

Collapse this tableExpand this table

SQL Hotfix bug number	Knowledge Base article number	Description
50001251	937041 (http://support.microsoft.com/kb/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 (http://support.microsoft.com/kb/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"

Back to the top

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.

Collapse this tableExpand this table

SQL Hotfix bug number	Knowledge Base article number	Description
50001020	936185 (http://support.microsoft.com/kb/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 (http://support.microsoft.com/kb/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 (http://support.microsoft.com/kb/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 (http://support.microsoft.com/kb/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 (http://support.microsoft.com/kb/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 (http://support.microsoft.com/kb/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 (http://support.microsoft.com/kb/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 (http://support.microsoft.com/kb/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 (http://support.microsoft.com/kb/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 (http://support.microsoft.com/kb/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

Back to the top

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.

Collapse this tableExpand this table

SQL Hotfix bug number	Knowledge Base article number	Description
50001001	932610 (http://support.microsoft.com/kb/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 (http://support.microsoft.com/kb/935922/ )	FIX: Error message when you install Microsoft Dynamics CRM 3.0: "Setup failed to validate specified Reporting Services Report Server"
50000926	935360 (http://support.microsoft.com/kb/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 (http://support.microsoft.com/kb/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 (http://support.microsoft.com/kb/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 (http://support.microsoft.com/kb/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 (http://support.microsoft.com/kb/935832/ )	FIX: You cannot cancel an MDX query that runs for a long time in SQL Server 2005 Analysis Services

Back to the top

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 (http://support.microsoft.com/kb/935356/ ) Cumulative update package (build 3161) for SQL Server 2005 Service Pack 2 is available

Back to the top

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.

Collapse this tableExpand this table

SQL Hotfix bug number	Knowledge Base article number	Description
50001012	934459 (http://support.microsoft.com/kb/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

Back to the top

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.

Collapse this tableExpand this table

SQL Hotfix bug number	Knowledge Base article number	Description
50000958	934226 (http://support.microsoft.com/kb/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)"

Back to the top

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.

Collapse this tableExpand this table

SQL Hotfix bug number	Knowledge Base article number	Description
50000900	933549 (http://support.microsoft.com/kb/933549/ )	FIX: You may receive an access violation when you perform a bulk copy operation in SQL Server 2005
50000964	933724 (http://support.microsoft.com/kb/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 (http://support.microsoft.com/kb/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 (http://support.microsoft.com/kb/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 (http://support.microsoft.com/kb/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 (http://support.microsoft.com/kb/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"

Back to the top

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.

Collapse this tableExpand this table

SQL Hotfix bug number	Knowledge Base article number	Description
50000948	934106 (http://support.microsoft.com/kb/934106/ )	FIX: SQL Server 2005 database engine generates failed assertion errors when you use the Replication Monitor to monitor the distribution database
50000952	934188 (http://support.microsoft.com/kb/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 (http://support.microsoft.com/kb/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.

Back to the top

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.

Collapse this tableExpand this table

SQL Hotfix bug number	Knowledge Base article number	Description
50000945	933564 (http://support.microsoft.com/kb/933564/ )	FIX: A gradual increase in memory consumption for the USERSTORE_TOKENPERM cache store occurs in SQL Server 2005

Back to the top

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 (http://support.microsoft.com/kb/933097/ ) Cumulative hotfix package (build 3152) for SQL Server 2005 Service Pack 2 is available

Back to the top

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.

Collapse this tableExpand this table

VSTS number	Knowledge Base article number	Description
261044	960089 (http://support.microsoft.com/kb/960089/ )	MS09-004: Description of the security update for SQL Server 2005 GDR: February 10, 2009

Back to the top

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.

Collapse this tableExpand this table

SQL Hotfix bug number	Knowledge Base article number	Description
50002995	954606 (http://support.microsoft.com/kb/954606/ )	MS08-052: Description of the security update for GDI+ for SQL Server 2005 Service Pack 2 GDR: September 9, 2008

Back to the top

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.

Collapse this tableExpand this table

SQL Hotfix bug number	Knowledge Base article number	Description
50002341	948109 (http://support.microsoft.com/kb/948109/ )	MS08-040: Description of the security update for SQL Server 2005 GDR: July 8, 2008

Back to the top

Build 09.00.3054

This build was released on March 4, 2007.

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

Collapse this tableExpand this table

SQL Hotfix bug number	Knowledge Base article number	Description
50001012	934458 (http://support.microsoft.com/kb/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

Back to the top

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.

Collapse this tableExpand this table

SQL Hotfix bug number	Knowledge Base article number	Description
50002426	942980 (http://support.microsoft.com/kb/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 (http://support.microsoft.com/kb/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"

Back to the top

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 (http://support.microsoft.com/kb/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 (http://support.microsoft.com/kb/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:

http://go.microsoft.com/fwlink/?LinkId=71711 (http://go.microsoft.com/fwlink/?LinkId=71711)

For more information about articles in the Microsoft Knowledge Base that apply to SQL Server 2005 and SQL Server 2008, click the following article number to view the article in the Microsoft Knowledge Base:

957826 (http://support.microsoft.com/kb/957826/ ) Where you can find more information about the SQL Server 2008 builds that were released after SQL Server 2008 and the SQL Server 2005 builds that were released after SQL Server 2005 Service Pack 2

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 (http://support.microsoft.com/kb/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 (http://support.microsoft.com/kb/824684/LN/ ) Description of the standard terminology that is used to describe Microsoft software updates

Back to the top

APPLIES TO

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

Back to the top

kbhowto kbinfo KB937137

Back to the top

Get Help Now

Contact a support professional by E-mail, Online, or Phone

Article Translations

Related Support Centers

SQL Server 2005

Get Help Now

Contact a support professional by E-mail, Online, or Phone

Microsoft Support

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

On This Page

INTRODUCTION

MORE INFORMATION

Build 09.00.3355 (cumulative update)

Build 09.00.3330 (cumulative update)

Build 09.00.3328 (cumulative update)

Build 09.00.3327

Build 09.00.3325 (cumulative update)

Build 09.00.3320

Build 09.00.3315 (cumulative update)

Build 09.00.3310

Build 09.00.3303

Build 09.00.3302

Build 09.00.3301 (cumulative update)

Build 09.00.3295

Build 09.00.3294 (cumulative update)

Build 09.00.3291

Build 09.00.3289

Build 09.00.3282 (cumulative update)

Build 09.00.3263

Build 09.00.3262

Build 09.00.3261

Build 09.00.3260

Build 09.00.3259

Build 09.00.3257 (cumulative update)

Build 09.00.3253

Build 09.00.3248

Build 09.00.3246

Build 09.00.3244

Build 09.00.3242

Build 09.00.3240

Build 09.00.3239 (cumulative update)

Build 09.00.3235

Build 09.00.3233

Build 09.00.3232

Build 09.00.3231

Build 09.00.3230

Build 09.00.3228 (cumulative update)

Build 09.00.3224

Build 09.00.3222

Build 09.00.3221

Build 09.00.3215 (cumulative update)

Build 09.00.3209

Build 09.00.3208

Build 09.00.3206

Build 09.00.3205

Build 09.00.3203

Build 09.00.3200 (cumulative update)

Build 09.00.3195

Build 09.00.3194

Build 09.00.3186 (cumulative update)

Build 09.00.3182

Build 09.00.3180

Build 09.00.3179

Build 09.00.3178

Build 09.00.3177

Build 09.00.3175 (cumulative update)

Build 09.00.3169

Build 09.00.3166

Build 09.00.3162

Build 09.00.3161 (cumulative update)

Build 09.00.3159

Build 09.00.3156

Build 09.00.3155

Build 09.00.3154

Build 09.00.3153

Build 09.00.3152

Build 09.00.3077

Build 09.00.3073

Build 09.00.3068

Build 09.00.3054

Build 09.00.3042 (SQL Server 2005 Service Pack 2)

REFERENCES

APPLIES TO

Keywords:

Provide feedback on this information

Get Help Now

Article Translations

Related Support Centers