SQLBlog.org

archives disclaimers
archives shortcuts bad habits
disclaimers
SQLBlog Home
bad habits
shortcuts
MERGE NOLOCK dates dynamic SQL
splitting SQL Server 2022 how to ask

An update on recent SQL Server 2005 builds

Aaron Bertrand SQL Server / SQL Server 2005 2

I'm still waiting for the latest GDR / QFE that is going to clean up (no pun intended) all the maintenance plan cleanup issues that were borne out of SP2 and the followup fixes. In the meantime, I've collected a list of build #s and their associated KBs that have happened since, well, the last time I did this.

Build # KB / Title Date
9.00.3152 KB933097 : Cumulative hotfix package (build 3152) for SQL Server 2005 Service Pack 2 is available 2007-03-07
9.00.3050 KB933508 : Microsoft SQL Server 2005 Service Pack 2 issue: Cleanup tasks run at different intervals than intended 2007-03-23
9.00.3043 Service Pack 2 Refresh 2007-03-07
9.00.3042 Service Pack 2 2007-02-19
9.00.3026 KB929376 : FIX: A "17187" error message may be logged in the Errorlog file when an instance of SQL Server 2005 is under a heavy load 2007-03-01
9.00.2215 KB931666 : FIX: An assertion violation may be logged after you install SQL Server 2005 or after you add more processors to a server that is running SQL Server 2005 2007-02-27
9.00.2214 KB929240 : FIX: I/O requests that are generated by the checkpoint process may cause I/O bottlenecks if the I/O subsystem is not fast enough to sustain the IO requests in SQL Server 2005 2007-02-13
9.00.2214 KB930505 : FIX: Error message when you run DML statements against a table that is published for merge replication in SQL Server 2005: "Could not find stored procedure" 2007-02-19
9.00.2211 KB930283 : FIX: You receive error 1456 when you add a witness to a database mirroring session and the database name is the same as an existing database mirroring session in SQL Server 2005 2007-02-14
9.00.2211 KB930284 : FIX: You receive error 1456 when you try to add a witness to a DBM session in SQL Server 2005 2007-02-20
9.00.2209 KB929278 : FIX: SQL Server 2005 may not perform histogram amendments when you use trace flags 2389 and 2390 2007-02-07
9.00.2208 KB929179 : FIX: A memory leak may occur every time that you synchronize a SQL Server Mobile subscriber in SQL Server 2005 2007-01-09
9.00.2208 KB929404 : FIX: Error message when you perform a transaction log backup operation and another data backup operation in parallel in SQL Server 2005: "Error 3633" 2007-02-28
9.00.2207 KB928372 : FIX: Error message when you use a synonym for a stored procedure in SQL Server 2005: "A severe error occurred on the current command" 2007-02-28
9.00.2207 KB928394 : FIX: The changes are not reflected in the publication database after you reinitialize the subscriptions in SQL Server 2005 2006-12-19
9.00.2207 KB928789 : FIX: Error message in the database mail log when you try to use the sp_send_dbmail stored procedure to send an e-mail in SQL Server 2005: "Invalid XML message format received on the ExternalMailQueue" 2007-01-02
9.00.2206 KB928083 : FIX: You may receive an error message when you run a CLR stored procedure or CLR function that uses a context connection in SQL Server 2005 2007-02-01
9.00.2206 KB928537 : FIX: The full-text index population for the indexed view is very slow in SQL Server 2005 2007-01-12
9.00.2202 KB927643 : FIX: Some search results are missing when you perform a full-text search operation on a Windows SharePoint Services 2.0 site after you upgrade to SQL Server 2005 2007-02-16
9.00.2201 KB927289 : FIX: Updates to the SQL Server Mobile subscriber may not be reflected in the SQL Server 2005 merge publication 2007-01-10
9.00.2198 KB924686 : FIX: The database mirroring session may remain in the synchronizing state and may stop responding when a database failover occurs in SQL Server 2005 2007-03-01
9.00.2198 KB924807 : FIX: The restore operation may take a long time to finish when you restore a database in SQL Server 2005 2007-02-02
9.00.2198 KB925277 : FIX: You may experience very large growth increments of a principal database after you manually fail over a database mirroring session in SQL Server 2005 2007-01-11
9.00.2198 KB926106 : FIX: You receive an error message when you use the Print Preview option on a large report in SQL Server 2005 Reporting Services 2007-02-20
9.00.2198 KB926612 : FIX: SQL Server Agent does not send an alert quickly or does not send an alert when you use an alert of the SQL Server event alert type in SQL Server 2005 2007-01-04
9.00.2198 KB926613 : FIX: You may receive incorrect results when you query a table that is published in a transactional replication in SQL Server 2005 2007-03-07
9.00.2196 KB926024 : FIX: The query performance is very slow when you use a fast forward-only cursor to run a query in SQL Server 2005 2007-03-02
9.00.2195 KB926240 : FIX: SQL Server 2005 may stop responding when you use the SqlBulkCopy class to import data from another data source 2006-12-19
9.00.2183 KB924291 : FIX: Error message when you execute a user-defined function in SQL Server 2005: "Invalid length parameter passed to the SUBSTRING function" or "A transport-level error has occurred when receiving results from the server" 2007-02-26
9.00.2181 KB923605 : FIX: A deadlock occurs and a query never finishes when you run the query on a computer that is running SQL Server 2005 and has multiple processors 2007-02-19
9.00.2176 KB922594 : FIX: Error message when you use SQL Server 2005: "High priority system task thread Operating system error Exception 0xAE encountered" 2007-02-12
9.00.2175 KB920794 : FIX: The size of the e-mail message is very large when you use Database Mail in SQL Server 2005 to send query results to users 2007-02-26
9.00.2175 KB921536 : FIX: A handled access violation may occur in the CValSwitch::GetDataX function when you run a complex query in SQL Server 2005 2006-12-18
9.00.2175 KB922579 : FIX: The operation may take longer than you expect when you run a warm query to obtain information from the Microsoft Search service in SQL Server 2005 2007-02-28
9.00.2167 KB921293 : FIX: The description for the Dimension field is not set in the local cube file when you use the CREATE LOCAL CUBE statement in SQL Server 2005 2007-03-08
9.00.2167 KB921295 : FIX: You may receive an incorrect result when you try to run a Multidimensional Expressions (MDX) query by using SQL Server 2005 2007-03-08
9.00.2164 KB918832 : FIX: An inefficient or incorrect SQL query is generated when you try to use SQL Server 2005 to browse a ROLAP dimension 2007-03-09
9.00.2164 KB919243 : FIX: Some rows in the Text Data column are always displayed for a trace that you create by using SQL Server Profiler in SQL Server 2005 2007-02-15
9.00.1558 KB926493 : FIX: Error message when you restore a transaction-log backup that is generated in SQL Server 2000 SP4 to an instance of SQL Server 2005: "Msg 3456, Level 16, State 1, Line 1. Could not redo log record" 2007-01-04
9.00.1551 KB922527 : FIX: Error message when you schedule some SQL Server 2005 Integration Services packages to run as jobs: "Package has been cancelled" 2007-03-02
9.00.1545 KB919193 : FIX: A forward-only cursor may be implicitly converted to a keyset cursor in SQL Server 2005 2007-02-28
9.00.1532 KB916046 : FIX: Indexes may grow very large when you insert a row into a table and then update the same row in SQL Server 2005 2007-01-09
9.00.1528 KB915306 : FIX: The merge agent fails and a "permission denied" error message is logged when you synchronize a SQL Server 2005-based merge publication 2007-01-08
9.00.1528 KB915307 : FIX: You experience a slow uploading process if conflicts occur when many merge agents upload changes to the publishers at the same time in SQL Server 2005 2007-01-11
9.00.1528 KB915308 : FIX: The CPU usage of the server reaches 100% when many DML activities occur in SQL Server 2005 2007-01-04
9.00.1528 KB915309 : FIX: When you start a merge agent, synchronization between the subscriber and the publisher takes a long time to be completed in SQL Server 2005 2007-01-15
9.00.1519 KB913494 : FIX: The merge agent does not use a specified custom user update to handle conflicting UPDATE statements in SQL Server 2005 2007-01-20

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 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. :-)

2 Responses

  1. AaronBertrand says:
    April 5, 2007 at 4:55 AM

    Thanks, see my most recent entry, posted that before I saw these comments.  
    Cheers,
    Aaron

  2. KB says:
    April 4, 2007 at 4:09 PM

    The following KBs release on the 3rd of April may be of interest.
    http://support.microsoft.com/?kbid=934458
    http://support.microsoft.com/?kbid=934459