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

Aaron Bertrand

I am a passionate technologist with industry experience dating back to Classic ASP and SQL Server 6.5. I am a long-time Microsoft MVP, write at Simple Talk, SQLPerformance, and MSSQLTips, and have had the honor of speaking at more conferences than I can remember. In non-tech life, I am a father of two, a huge hockey and football fan, and my pronouns are he/him. If I've helped you out, consider thanking me with a coffee. :-)