Some new and updated SQL Server 2005 builds

Updated: 2007-07-02

Continuing with a great tradition, I present again an updated list of SQL Server builds and hotfixes that have been released since the last time I posted a similar list (beginning of May). The cumulative fix build 3152 is available for public download. Most others need to be obtained through support.

KB title	Build #	Date
Cumulative update package 2 for SQL Server 2005 Service Pack 2 is available	3175	June 22, 2007
FIX: A foreign key constraint that you drop on a table at the publisher is not dropped on the table at the subscriber in a SQL Server 2005 merge replication	3175	June 29, 2007
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	3171	June 13, 2007
FIX: Error message when you run a linked server query in SQL Server 2005: "The oledbprovider unisys.dmsII.1 for linkserver '' reported an error the provider ran out of memory"	3169	June 19, 2007
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	3169	May 25, 2007
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	3166	June 11, 2007
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"	3166	May 22, 2007
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	3161	May 9, 2007
FIX: Error message when you run a query that contains nested FOR XML clauses in SQL Server 2005: “The XML data type is damaged”	3155	June 13, 2007
Cumulative hotfix package (build 3152) for SQL Server 2005 Service Pack 2 is available	3152	June 29, 2007
FIX: SQL Server 2005 stops and then restarts unexpectedly and errors occur in the tempdb database	2234	June 20, 2007
FIX: Error message when you use the BULK INSERT statement to import a data file into a table in SQL Server 2005 with SP1: "The OLE DB provider "BULK" for linked server "(null)" reported an error"	2233	June 18, 2007
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"	2233	June 12, 2007
FIX: You may receive error 3456 when you try to restore a transaction log for a SQL Server 2005 database	2233	June 5, 2007
FIX: A memory leak occurs when you use the sp_OAMethod stored procedure to call a method of a COM object in SQL Server 2005	2232	June 19, 2007
FIX: You receive error messages when you use the BULK INSERT statement in SQL Server 2005 to import data in bulk	2229	June 11, 2007
FIX: You may receive error 1203 when you run an INSERT statement against a table that has an identity column in SQL Server 2005	2227	June 26, 2007
FIX: You receive error 18815 when the Log Reader Agent runs for a transactional publication in SQL Server 2005	2226	June 22, 2007
FIX: Error message when the Replication Merge Agent runs to synchronize a merge replication subscription in SQL Server 2005: “The merge process failed to execute a query because the query timed out”	2226	June 22, 2007
FIX: You may experience poor performance after you install SQL Server 2005 Service Pack 1	2223	June 18, 2007
FIX: Lots of messages that have message ID 19030 and message ID 19031 are logged in the SQL Server 2005 Errorlog file when you use SQL Server Profile in SQL Server 2005	2175	June 27, 2007
FIX: When you query through a view that uses the ORDER BY clause in SQL Server 2005, the result is still returned in random order	1554	June 26, 2007
FIX: When you run the "dbcc dbreindex" command or the "alter index" command, some transactions are not replicated to the subscribers in a transactional replication in SQL Server 2005	1534	May 15, 2007