Blog Post

Microsoft SQL Server 2005 Builds

,

The following table lists all builds of SQL Server 2005 known hotfixes, service packs and KB articles that have been released by Microsoft.

Quick Overview:

CodenameRTM/Service PackBuild Number
 YukonRTM9.00.1399.06
SP19.00.2047
SP29.00.3042
SP39.00.4035
SP49.00.5000

Microsoft SQL Server 2005 Builds Breakdown:

BuildFile versionKB / DescriptionRelease Date
9.00.53242005.90.5324.02716427 MS12-070: Description of the security update for SQL Server 2005 Service Pack 4 QFEOctober 9, 2012
9.00.52962005.90.5296.02615425 FIX: “Msg 7359″ error when a view uses another view in SQL Server 2005 if the schema version of a remote table is updatedOctober 24, 2011
9.00.52952005.90.5295.02598903 FIX: SQL Server Agent job randomly stops when you schedule the job to run past midnight on specific days in SQL Server 2005, in SQL Server 2008 or in SQL Server 2008 R2May 21, 2012
9.00.52942005.90.5294.02572407 FIX: Error 5180 when you use the ONLINE option to rebuild an index in SQL Server 2005August 10, 2011
9.00.52922005.90.5292.02494123 MS11-049: Description of the security update for SQL Server 2005 Service Pack 4 QFE: June 14, 2011June 14, 2011
9.00.52662005.90.5266.02507769 Cumulative update package 3 (CU3) for SQL Server 2005 Service Pack 4March 22, 2011
9.00.52592005.90.5259.02489409 Cumulative update package 2 (CU2) for SQL Server 2005 Service Pack 4February 22, 2011
9.00.52542005.90.5254.02464079 Cumulative update package 1 (CU1) for SQL Server 2005 Service Pack 4December 24, 2010
9.00.50692005.90.5069.0Microsoft Security Bulletin MS12-070October 9, 2012
9.00.50572005.90.5057.02494120 MS11-049: Description of the security update for SQL Server 2005 Service Pack 4 GDR: June 14, 2011June 14, 2011
9.00.50002005.90.5000.0SQL Server 2005 Service Pack 4 (SP4)December 17, 2010
9.00.49122005.90.4912.0SQL Server 2005 Service Pack 4 (SP4) – Customer Technology Preview (CTP)November 3, 2010
9.00.43422005.90.4342.02598903 FIX: SQL Server Agent job randomly stops when you schedule the job to run past midnight on specific days in SQL Server 2005, in SQL Server 2008 or in SQL Server 2008 R2May 21, 2012
9.00.43402005.90.4340.02494112 MS11-049: Description of the security update for SQL Server 2005 Service Pack 3 QFE: June 14, 2011June 14, 2011
9.00.43252005.90.4325.02507766 Cumulative update package 15 (CU15) for SQL Server 2005 Service Pack 3March 22, 2011
9.00.43172005.90.4317.02489375 Cumulative update package 14 (CU14) for SQL Server 2005 Service Pack 3February 21, 2011
9.00.43152005.90.4315.02438344 Cumulative update package 13 (CU13) for SQL Server 2005 Service Pack 3December 23, 2010
9.00.43112005.90.4311.02345449 Cumulative update package 12 (CU12) for SQL Server 2005 Service Pack 3October 18, 2010
9.00.43092005.90.4309.02258854 Cumulative update package 11 (CU11) for SQL Server 2005 Service Pack 3August 16, 2010
9.00.43052005.90.4305.0983329 Cumulative update package 10 (CU10) for SQL Server 2005 Service Pack 3June 23, 2010
9.00.42942005.90.4294.0980176 Cumulative update package 9 (CU9) for SQL Server 2005 Service Pack 3April 19, 2010
9.00.42852005.90.4285.0978915 Cumulative update package 8 (CU8) for SQL Server 2005 Service Pack 3February 16, 2010
9.00.42732005.90.4273.0976951 Cumulative update package 7 (CU7) for SQL Server 2005 Service Pack 3December 21, 2009
9.00.42682005.90.4268.0977151 FIX: Error message when you add a subscription to a republisher that is in a merge publication in SQL Server 2005: “Cannot create the subscription because the subscription already exists in the subscription database”December 21, 2009
9.00.42662005.90.4266.0974648 Cumulative update package 6 (CU6) for SQL Server 2005 Service Pack 3October 19, 2009
9.00.42622005.90.4262.0970894 MS09-062: Description of the security update for SQL Server 2005 Service Pack 3 QFE: October 13, 2009October 13, 2009
9.00.42302005.90.4230.0972511 Cumulative update package 5 (CU5) for SQL Server 2005 Service Pack 3August 17, 2009
9.00.42262005.90.4226.0970279 Cumulative update package 4 (CU4) for SQL Server 2005 Service Pack 3June 16, 2009
9.00.42242005.90.4224.0971409 FIX: Error message when you run a query that contains duplicate join conditions in SQL Server 2005: “Internal Query Processor Error: The query processor could not produce a query plan”June 16, 2009
9.00.42202005.90.4220.0967909 Cumulative update package 3 (CU3) for SQL Server 2005 Service Pack 3April 20, 2009
9.00.42162005.90.4216.0967101 FIX: The performance of database mirroring decreases when you run a database maintenance job that generates a large number of transaction log activities in SQL Server 2005April 20, 2009
9.00.42112005.90.4211.0961930 Cumulative update package 2 (CU2) for SQL Server 2005 Service Pack 3February 17, 2009
9.00.42072005.90.4207.0959195 Cumulative update package 1 (CU1) for SQL Server 2005 Service Pack 3December 20, 2008
9.00.40602005.90.4060.02494113 MS11-049: Description of the security update for SQL Server 2005 Service Pack 3 GDR: June 14, 2011June 14, 2011
9.00.40532005.90.4053.0970892 MS09-062: Description of the security update for SQL Server 2005 Service Pack 3 GDR: October 13, 2009October 13, 2009
9.00.40352005.90.4035.0SQL Server 2005 Service Pack 3 (SP3)December 15, 2008
9.00.40282005.90.4028.0SQL Server 2005 Service Pack 3 (SP3) – CTPOctober 27, 2008
9.00.33562005.90.3356.0976952 Cumulative update package 17 (CU17) for SQL Server 2005 Service Pack 2December 21, 2009
9.00.33552005.90.3355.0974647 Cumulative update package 16 (CU16) for SQL Server 2005 Service Pack 2October 19, 2009
9.00.33532005.90.3353.0970896 MS09-062: Description of the security update for SQL Server 2005 Service Pack 2 QFE: October 13, 2009October 13, 2009
9.00.33302005.90.3330.0972510 Cumulative update package 15 (CU15) for SQL Server 2005 Service Pack 2August 18, 2009
9.00.33282005.90.3328.0970278 Cumulative update package 14 (CU14) for SQL Server 2005 Service Pack 2June 16, 2009
9.00.33252005.90.3325.0967908 Cumulative update package 13 (CU13) for SQL Server 2005 Service Pack 2April 20, 2009
9.00.33202005.90.3320.0969142 FIX: Error message when you run the DBCC CHECKDB statement on a database in SQL Server 2005: “Unable to deallocate a kept page”April 1, 2009
9.00.33182005.90.3318.0967199 FIX: The Wmiprvse.exe host process stops responding when you run a SQL Server 2005-based application that sends a Windows Management Instrumentation (WMI) query to the SQL Server WMI providerApril 20, 2009
9.00.33152005.90.3315.0962970 Cumulative update package 12 (CU12) for SQL Server 2005 Service Pack 2February 17, 2009
9.00.33102005.90.3310.0960090 MS09-004: Description of the security update for SQL Server 2005 QFE: February 10, 2009February 10, 2009
9.00.33012005.90.3301.0958735 Cumulative update package 11 (CU11) for SQL Server 2005 Service Pack 2December 16, 2008
9.00.32942005.90.3294.0956854 Cumulative update package 10 (CU10) for SQL Server 2005 Service Pack 2October 20, 2008
9.00.32822005.90.3282.0953752 Cumulative update package 9 (CU9) for SQL Server 2005 Service Pack 2June 16, 2008
9.00.32602005.90.3260.0954950 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’”July 14, 2008
9.00.32592005.90.3259.0954831 FIX: In SQL Server 2005, the session that runs the TRUNCATE TABLE statement may stop responding, and you cannot end the sessionAugust 14, 2008
9.00.32592005.90.3259.0954669 FIX: An ongoing MS DTC transaction is orphaned in SQL Server 2005July 14, 2008
9.00.32572005.90.3257.0951217 Cumulative update package 8 (CU8) for SQL Server 2005 Service Pack 2June 18, 2008
9.00.32462005.90.3246.0952233 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 instanceMay 23, 2008
9.00.32442005.90.3244.0952330 FIX: The Replication Log Reader Agent may fail intermittently when a transactional replication synchronizes data in SQL Server 2005June 3, 2008
9.00.32402005.90.3240.0951204 FIX: An access violation occurs when you update a table through a view by using a cursor in SQL Server 2005May 21, 2008
9.00.32392005.90.3239.0949095 Cumulative update package 7 (CU7) for SQL Server 2005 Service Pack 2April 17, 2008
9.00.32322005.90.3232.0949959 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.’”March 19, 2008
9.00.32312005.90.3231.0949595 FIX: Error message when you run a query that uses a join condition in SQL Server 2005: “Non-yielding Scheduler”March 18, 2008
9.00.32312005.90.3231.0949687 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”March 14, 2008
9.00.32302005.90.3230.0949199 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”March 7, 2008
9.00.32282005.90.3228.0946608 Cumulative update package 6 (CU6) for SQL Server 2005 Service Pack 2February 19, 2008
9.00.32242005.90.3224.0947463 FIX: A stored procedure cannot finish its execution in SQL Server 2005February 4, 2008
9.00.32212005.90.3221.0942908 FIX: The change may be undone during the later synchronizations when you change an article on the subscriber in SQL Server 2005January 31, 2008
9.00.32212005.90.3221.0945443 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 queryJanuary 11, 2008
9.00.32212005.90.3221.0945916 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″January 10, 2008
9.00.32212005.90.3221.0945442 FIX: You cannot cancel the query execution immediately if you open a fast forward-only cursor for the query in SQL Server 2005January 9, 2008
9.00.32152005.90.3215.0943656 Cumulative update package 5 (CU5) for SQL Server 2005 Service Pack 2December 18, 2007
9.00.32082005.90.3208.0944902 FIX: A federated database server stops responding when you run parallel queries on a multiprocessor computer that uses NUMA architecture in SQL Server 2005November 21, 2007
9.00.32062005.90.3206.0944677 FIX: Conflicts are not logged when you use the Microsoft SQL Server Subscriber Always Wins Conflict Resolver for an article in a merge replication in Microsoft SQL Server 2005December 11, 2007
9.00.32002005.90.3200.0941450 Cumulative update package 4 (CU4) for SQL Server 2005 Service Pack 2October 17, 2007
9.00.31942005.90.3194.0940933 FIX: Some changes from subscribers who use SQL Server 2005 Compact Edition or Web synchronization are not uploaded to the publisher when you use the republishing model in a merge publication in Microsoft SQL Server 2005September 24, 2007
9.00.31862005.90.3186.0940943 FIX: The performance of a query that performs an insert operation or an update operation is much slower in SQL Server 2005 SP2 than in earlier versions of SQL Server 2005August 29, 2007
9.00.31862005.90.3186.0940378 FIX: A cursor uses the incorrect transaction isolation level after you change the transaction isolation level for the cursor in SQL Server 2005August 24, 2007
9.00.31862005.90.3186.0940269 FIX: Error message when you try to edit a SQL Server Agent job or a maintenance plan by using SQL Server Management Studio in SQL Server 2005: “String or binary data would be truncated”August 23, 2007
9.00.31862005.90.3186.0940945 FIX: Performance is very slow when the same stored procedure is executed at the same time in many connections on a multiple-processor computer that is running SQL Server 2005August 22, 2007
9.00.31862005.90.3186.0940937 FIX: Error message when you try to update the index key columns of a non-unique clustered index in SQL Server 2005: “Cannot insert duplicate key row in object ‘ObjectName’ with unique index ‘IndexName’”August 21, 2007
9.00.31862005.90.3186.0940379 FIX: Error message when you use the UNLOAD and REWIND options to back up a database to a tape device in SQL Server 2005: “Operation on device ‘<TapeDevice>’ exceeded retry count”August 20, 2007
9.00.31862005.90.3186.0940375 FIX: Error message when you use the Copy Database Wizard to move a database from SQL Server 2000 to SQL Server 2005August 20, 2007
9.00.31862005.90.3186.0937100 FIX: Error message when you run a SQL Server 2005 Integration Services package that contains a Script Component transformation:”Insufficient memory to continue the execution of the program”August 20, 2007
9.00.31862005.90.3186.0940126 FIX: Error 9003 is logged in the SQL Server error log file when you use log shipping in SQL Server 2005August 20, 2007
9.00.31862005.90.3186.0938363 FIX: Data is not replicated to a subscriber in a different partition by using parameterized row filters in SQL Server 2005August 17, 2007
9.00.31862005.90.3186.0940935 FIX: Error message when you run a query that is associated with a parallel execution plan in SQL Server 2005: “SQL Server Assertion: File: <lckmgr.cpp>, line=10850 Failed Assertion = ‘GetLocalLockPartition () == xactLockInfo->GetLocalLockPartition ()’”August 17, 2007
9.00.31862005.90.3186.0940221 FIX: Error message when you try to create an Oracle publication by using the New Publication Wizard in SQL Server 2005 Service Pack 2: “OLE DB Provider ‘OraOLEDB.ORACLE’ for Linked server <LinkedServerName> returned message”August 17, 2007
9.00.31862005.90.3186.0940942 FIX: Error message when you run a stored procedure that references tables after you upgrade a database from SQL Server 2000 to SQL Server 2005: “A time-out occurred while waiting for buffer latch”August 17, 2007
9.00.31862005.90.3186.0940384 FIX: You receive a System.InvalidCastException exception when you run an application that calls the Server.JobServer.Jobs.Contains method on a computer that has SQL Server 2005 Service Pack 2 installedAugust 13, 2007
9.00.31862005.90.3186.0940281 FIX: An access violation may occur, and you may receive an error message, when you query the sys.dm_exe_sessions dynamic management view in SQL Server 2005August 13, 2007
9.00.31862005.90.3186.0940545 FIX: The performance of insert operations against a table that contains an identity column may be slow in SQL Server 2005August 10, 2007
9.00.31862005.90.3186.0940210 FIX: Error message when you try to insert more than 3 megabytes of data into a distributed partitioned view in SQL Server 2005: “A system assertion check has failed”August 8, 2007
9.00.31862005.90.3186.0939537 Cumulative update package 3 (CU3) for SQL Server 2005 Service Pack 2August 23, 2007
9.00.31822005.90.3182.0940128 FIX: You receive error 8623 when you run a complex query in SQL Server 2005August 3, 2007
9.00.31792005.90.3179.0938243 FIX: Error message when you run a full-text query against a catalog in SQL Server 2005: “The execution of a full-text query failed. The content index is corrupt.”July 30, 2007
9.00.31782005.90.3178.0938086 FIX: A SQL Server Agent job fails when you run the SQL Server Agent job in the context of a proxy account in SQL Server 2005August 22, 2007
9.00.31772005.90.3177.0939285 FIX: Error message when you run a stored procedure that starts a transaction that contains a Transact-SQL statement in SQL Server 2005: “New request is not allowed to start because it should come with valid transaction descriptor”August 22, 2007
9.00.31772005.90.3177.0939562 FIX: Error message when you run a query that fires an INSTEAD OF trigger in SQL Server 2005 Service Pack 2: “Internal Query Processor Error The query processor could not produce a query plan”August 20, 2007
9.00.31772005.90.3177.0939563 FIX: Error message when you synchronize a merge replication in Microsoft SQL Server 2005: “MSmerge_del_<GUID>, Line 42 String or binary data would be truncated”August 9, 2007
9.00.31752005.90.3175.0936534 FIX: Error message when the Distribution Agent tries to apply the snapshot to the subscriber in SQL Server 2005: “Must declare the scalar variable “@Variable”"August 20, 2007
9.00.31752005.90.3175.0938671 FIX: The Distribution Agent may skip some rows when you configure a transactional replication that uses the “-SkipErrors” parameter in SQL Server 2005August 1, 2007
9.00.31752005.90.3175.0936488 The service pack update or hotfix installation stops unexpectedly when you try to install either Microsoft SQL Server 2005 Service Pack 2 or a hotfix for SQL Server 2005 SP2July 10, 2007
9.00.31752005.90.3175.0938825 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 replicationJune 29, 2007
9.00.31752005.90.3175.0936305 Cumulative update package 2 (CU2 build 3175) for SQL Server 2005 Service Pack 2 is availableJune 28, 2007
9.00.31712005.90.3171.0937745 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 connectionsJuly 16, 2007
9.00.31692005.90.3169.0937033 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”June 19, 2007
9.00.31692005.90.3169.0937041 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 2005May 25, 2007
9.00.31662005.90.3166.0936185 FIX: Blocking and performance problems may occur when you enable trace flag 1118 in SQL Server 2005 if the temporary table creation workload is highJune 11, 2007
9.00.31662005.90.3166.0934734 FIX: A database is marked as suspect when you update a table that contains a nonclustered index in SQL Server 2005July 16, 2007
9.00.31612005.90.3161.0935789 FIX: On a computer that is running SQL Server 2005 and that has multiple processors, you may receive incorrect results when you run a query that contains an inner joinSeptember 24, 2007
9.00.31612005.90.3161.0934706 FIX: Error message when you perform a piecemeal restore operation after you enable vardecimal database compression in SQL Server 2005 Service Pack 2: “Piecemeal restore is not supported when an upgrade is involved”June 4, 2007
9.00.31612005.90.3161.0933724 FIX: The query performance is slow when you run a query that uses a user-defined scalar function against an instance of SQL Server 2005May 9, 2007
9.00.31612005.90.3161.0935356 Cumulative update package (CU1 build 3161) for SQL Server 2005 Service Pack 2 is availableApril 16, 2007
9.00.31592005.90.3159.0934459 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 3158April 3, 2007
9.00.31562005.90.3156.0934226 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)”April 25, 2007
9.00.31552005.90.3155.0933808 FIX: Error message when you run a query that contains nested FOR XML clauses in SQL Server 2005: “The XML data type is damaged”June 13, 2007
9.00.31552005.90.3155.0933499 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”June 12, 2007
9.00.31552005.90.3155.0933766 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)”May 15, 2007
9.00.31552005.90.3155.0933549 FIX: You may receive an access violation when you perform a bulk copy operation in SQL Server 2005April 25, 2007
9.00.31542005.90.3154.0934188 FIX: The Distribution Agent does not deliver commands to the Subscriber even if the Distribution Agent is running in SQL Server 2005April 25, 2007
9.00.31542005.90.3154.0934109 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 2005April 25, 2007
9.00.31542005.90.3154.0934106 FIX: SQL Server 2005 database engine generates failed assertion errors when you use the Replication Monitor to monitor the distribution databaseApril 25, 2007
9.00.31532005.90.3153.0933564 FIX: A gradual increase in memory consumption for the USERSTORE_TOKENPERM cache store occurs in SQL Server 2005April 16, 2007
9.00.31522005.90.3152.0933097 Cumulative hotfix package (build 3152) for SQL Server 2005 Service Pack 2 is availableMarch 7, 2007
9.00.30802005.90.3080.0970895 MS09-062: Description of the security update for GDI+ for SQL Server 2005 Service Pack 2 GDR: October 13, 2009October 13, 2009
9.00.30772005.90.3077.0960089 MS09-004: Description of the security update for SQL Server 2005 GDR: February 10, 2009February 10, 2009
9.00.30732005.90.3073.0954606 MS08-052: Description of the security update for GDI+ for SQL Server 2005 Service Pack 2 GDR: September 9, 2008September 9, 2008
9.00.30682005.90.3068.0941203 MS08-040: Vulnerabilities in Microsoft SQL Server could allow elevation of privilegeAugust 5, 2008
9.00.30542005.90.3054.0934458 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 3053January 2, 2008
9.00.30502005.90.3050.0933508 Microsoft SQL Server 2005 Service Pack 2 issue: Cleanup tasks run at different intervals than intendedMarch 7, 2007
9.00.30422005.90.3042.0SQL Server 2005 Service Pack 2 (SP2)February 19, 2007
9.00.30332005.90.3033.0SQL Server 2005 Service Pack 2 (SP2) – CTP December 2006December 19, 2006
9.00.30272005.90.3027.0SQL Server 2005 Service Pack 2 (SP2) – CTP November 2006November 6, 2006
9.00.30262005.90.3026.0929376 FIX: A “17187″ error message may be logged in the Errorlog file when an instance of SQL Server 2005 is under a heavy loadFebruary 14, 2007
9.00.22392005.90.2239.0940961 FIX: Transactions that are being committed on the principal server may not be copied to the mirror server when a database mirroring failover occurs in SQL Server 2005September 24, 2007
9.00.22372005.90.2237.0940719 FIX: A memory leak occurs when you call the Initialize method and the Terminate method of the SQLDistribution object in a loop in an application that you develop by using Microsoft ActiveX replication controls in SQL Server 2005September 24, 2007
9.00.22362005.90.2236.0940287 FIX: Error message when you use Service Broker in SQL Server 2005: “An error occurred while receiving data: ’64(The specified network name is no longer available.)’”July 29, 2007
9.00.22362005.90.2236.0940286 FIX: A Service Broker endpoint stops passing messages in a database mirroring session of SQL Server 2005July 26, 2007
9.00.22342005.90.2234.0937343 FIX: SQL Server 2005 stops and then restarts unexpectedly and errors occur in the tempdb databaseJune 20, 2007
9.00.22332005.90.2233.0937545 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”June 18, 2007
9.00.22332005.90.2233.0933499 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”June 12, 2007
9.00.22332005.90.2233.0937544 FIX: You may receive error 3456 when you try to restore a transaction log for a SQL Server 2005 databaseJune 5, 2007
9.00.22322005.90.2232.0937277 FIX: A memory leak occurs when you use the sp_OAMethod stored procedure to call a method of a COM object in SQL Server 2005June 19, 2007
9.00.22312005.90.2231.0934812 FIX: You cannot bring the SQL Server group online in a cluster environment after you rename the virtual server name of the default instance of SQL Server 2005November 6, 2007
9.00.22302005.90.2230.0936179 FIX: Error message when you use SQL Native Client to connect to an instance of a principal server in a database mirroring session: “The connection attempted to fail over to a server that does not have a failover partner”September 20, 2007
9.00.22292005.90.2229.0935446 FIX: You receive error messages when you use the BULK INSERT statement in SQL Server 2005 to import data in bulkJune 11, 2007
9.00.22272005.90.2227.0933265 FIX: You may receive error 1203 when you run an INSERT statement against a table that has an identity column in SQL Server 2005June 26, 2007
9.00.22262005.90.2226.0934065 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”June 22, 2007
9.00.22262005.90.2226.0933762 FIX: You receive error 18815 when the Log Reader Agent runs for a transactional publication in SQL Server 2005June 22, 2007
9.00.22232005.90.2223.0932393 FIX: You may experience poor performance after you install SQL Server 2005 Service Pack 1June 18, 2007
9.00.22212005.90.2221.0931593 FIX: A script task or a script component may not run correctly when you run an SSIS package in SQL Server 2005 build 2153 and later buildsJuly 11, 2007
9.00.22192005.90.2219.0932115 FIX: The ghost row clean-up thread does not remove ghost rows on some data files of a database in SQL Server 2005April 25, 2007
9.00.22182005.90.2218.0931843 FIX: SQL Server 2005 does not reclaim the disk space that is allocated to the temporary table if the stored procedure is stoppedApril 25, 2007
9.00.22162005.90.2216.0931821 FIX: High CPU utilization by SQL Server 2005 may occur when you use NUMA architecture on a computer that has an x64-based version of SQL Server 2005 installedMay 15, 2007
9.00.22142005.90.2214.0930505 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”February 19, 2007
9.00.22142005.90.2214.0929240 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 2005February 13, 2007
9.00.22112005.90.2211.0930284 FIX: You receive error 1456 when you try to add a witness to a DBM session in SQL Server 2005February 20, 2007
9.00.22112005.90.2211.0930283 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 2005February 14, 2007
9.00.22092005.90.2209.0929278 FIX: SQL Server 2005 may not perform histogram amendments when you use trace flags 2389 and 2390February 7, 2007
9.00.22082005.90.2208.0929179 FIX: A memory leak may occur every time that you synchronize a SQL Server Mobile subscriber in SQL Server 2005January 9, 2007
9.00.22072005.90.2207.0928394 FIX: The changes are not reflected in the publication database after you reinitialize the subscriptions in SQL Server 2005December 19, 2006
9.00.22072005.90.2207.0928372 FIX: Error message when you use a synonym for a stored procedure in SQL Server 2005: “A severe error occurred on the current command”December 19, 2006
9.00.22072005.90.2207.0928789 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”January 2, 2007
9.00.22062005.90.2206.0928083 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 2005February 1, 2007
9.00.22062005.90.2206.0928537 FIX: The full-text index population for the indexed view is very slow in SQL Server 2005January 12, 2007
9.00.22062005.90.2206.0926493 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”January 2, 2007
9.00.22062005.90.2206.0928539 FIX: An access violation is logged in the SQL Server Errorlog file when you run a query that uses a plan guide in SQL Server 2005December 13, 2006
9.00.22022005.90.2202.0927643 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 2005February 16, 2007
9.00.22012005.90.2201.0927289 FIX: Updates to the SQL Server Mobile subscriber may not be reflected in the SQL Server 2005 merge publicationJanuary 10, 2007
9.00.21982005.90.2198.0926613 FIX: You may receive incorrect results when you query a table that is published in a transactional replication in SQL Server 2005February 21, 2007
9.00.21982005.90.2198.0926106 FIX: You receive an error message when you use the Print Preview option on a large report in SQL Server 2005 Reporting ServicesFebruary 20, 2007
9.00.21982005.90.2198.0924807 FIX: The restore operation may take a long time to finish when you restore a database in SQL Server 2005February 2, 2007
9.00.21982005.90.2198.0924264 FIX: The metadata of the Description object of a Key Performance Indicator appears in the default language after you define a translation for the Description object in SQL Server 2005 Business Intelligence Development StudioDecember 13, 2006
9.00.21982005.90.2198.0926612 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 2005January 4, 2007
9.00.21982005.90.2198.0926773 FIX: Error message when you run a query that uses a fast forward-only cursor in SQL Server 2005: “Query processor could not produce a query plan because of the hints defined in this query”November 16, 2006
9.00.21982005.90.2198.0926611 FIX: SQL Server 2005 may not send a message notification that is based on the specific string in the forwarded event when a computer that is running SQL Server 2000 forwards an event to a computer that is running SQL Server 2005November 28, 2006
9.00.21982005.90.2198.0924808 FIX: You receive an error message, or you obtain an incorrect result when you query data in a partitioned table that does not have a clustered index in SQL Server 2005December 13, 2006
9.00.21982005.90.2198.0925277 FIX: You may experience very large growth increments of a principal database after you manually fail over a database mirroring session in SQL Server 2005January 2, 2007
9.00.21962005.90.2196.0926285 Fix: Error message when you convert a column from the varbinary(max) data type to the XML data type in SQL Server 2005: “Msg 6322, Level 16, State 1, Line 2 Too many attributes or namespace definitions”November 10, 2006
9.00.21962005.90.2196.0926335 FIX: Error message when you trace the Audit Database Management event and you try to bring a database online in SQL Server 2005: “Msg 942, Level 14, State 4, Line 1”December 5, 2006
9.00.21952005.90.2195.0926240 FIX: SQL Server 2005 may stop responding when you use the SqlBulkCopy class to import data from another data sourceDecember 19, 2006
9.00.21942005.90.2194.0925744 FIX: Error message when you try to use a SQL Server authenticated login to log on to an instance of SQL Server 2005: “Logon error: 18456″October 20, 2006
9.00.21922005.90.2192.0924954 FIX: Error message when you use a table-valued function (TVF) together with the CROSS APPLY operator in a query in SQL Server 2005: “There is insufficient system memory to run this query”September 29, 2006
9.00.21922005.90.2192.0925335 FIX: Error message when you use a label after a Transact-SQL query in SQL Server 2005: “Incorrect syntax near ‘X’”October 5, 2006
9.00.21912005.90.2191.0925135 FIX: An empty string is replicated as a NULL value when you synchronize a table to a SQL Server 2005 Compact Edition subscriberDecember 6, 2006
9.00.21902005.90.2190.0925227 FIX: Error message when you call the SQLTables function against an instance of SQL Server 2005: “Invalid cursor state (0)”October 16, 2006
9.00.21892005.90.2189.0925153 FIX: You may receive different date values for each row when you use the getdate function within a case statement in SQL Server 2005September 22, 2006
9.00.21872005.90.2187.0923849 FIX: When you run a query that references a partitioned table in SQL Server 2005, query performance may decreaseSeptember 22, 2006
9.00.21812005.90.2181.0923605 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 processorsFebruary 19, 2007
9.00.21812005.90.2181.0923624 FIX: Error message when you run an application against SQL Server 2005 that uses many unique user logins or performs many user login impersonations: “insufficient system memory to run this query”October 4, 2006
9.00.21762005.90.2176.0922594 FIX: Error message when you use SQL Server 2005: “High priority system task thread Operating system error Exception 0xAE encountered”February 12, 2007
9.00.21762005.90.2176.0923296 FIX: Log Reader Agent fails, and an assertion error message is logged when you use transactional replication in SQL Server 2005September 6, 2006
9.00.21752005.90.2175.0921395 FIX: The color and the background image may not appear when you try to display a report in HTML format in Report Manager in SQL Server 2005 Reporting ServicesAugust 8, 2006
9.00.21752005.90.2175.0917905 FIX: SQL Server 2005 performance may be slower than SQL Server 2000 performance when you use an API server cursorAugust 14, 2006
9.00.21752005.90.2175.0922578 FIX: In SQL Server 2005, the sp_altermessage stored procedure does not suppress system error messages that are logged in the SQL Server error log and in the Application logAugust 30, 2006
9.00.21752005.90.2175.0922438 FIX: A query may take a long time to compile when the query contains several JOIN clauses against a SQL Server 2005 databaseDecember 14, 2006
9.00.21752005.90.2175.0921536 FIX: A handled access violation may occur in the CValSwitch::GetDataX function when you run a complex query in SQL Server 2005December 18, 2006
9.00.21742005.90.2174.0922063 FIX: You may notice a large increase in compile time when you enable trace flags 2389 and 2390 in SQL Server 2005 Service Pack 1July 25, 2006
9.00.21672005.90.2167.0920974 FIX: SQL Server 2005 treats an identity column in a view as an ordinary int column when the compatibility level of the database is set to 80August 9, 2006
9.00.21642005.90.2164.0919243 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 2005February 8, 2007
9.00.21642005.90.2164.0920346 FIX: SQL Server 2005 may overestimate the cardinality of the JOIN operator when a SQL Server 2005 query contains a join predicate that is a multicolumn predicateSeptember 19, 2006
9.00.21642005.90.2164.0920347 FIX: The SQL Server 2005 query optimizer may incorrectly estimate the cardinality for a query that has a predicate that contains an index union alternativeSeptember 19, 2006
9.00.21642005.90.2164.0919929 FIX: Error message when the Replication Merge Agent runs in SQL Server 2005: “Source: MSSQL_REPL, Error number: MSSQL_REPL-2147199402″October 26, 2006
9.00.21642005.90.2164.0921003 FIX: You may receive an error message when you manually define a Back Up Database task in SQL Server 2005 to back up the transaction logAugust 29, 2006
9.00.21642005.90.2164.0920206 FIX: System performance may be slow when an application submits many queries against a SQL Server 2005 database that uses simple parameterizationSeptember 26, 2006
9.00.21642005.90.2164.0918882 FIX: A query plan is not cached in SQL Server 2005 when the text of the hint is a large objectSeptember 6, 2006
9.00.21642005.90.2164.0919636 FIX: Memory usage of the compiled query plan may unexpectedly increase in SQL Server 2005July 26, 2006
9.00.21642005.90.2164.0919775 FIX: The BULK INSERT statement may not return any errors when you try to import data from a text file to a table by using the BULK INSERT statement in Microsoft SQL Server 2005August 9, 2006
9.00.21562005.90.2156.0919611 FIX: The value of the automatic growth increment of a database file may be very large in SQL Server 2005 with Service Pack 1July 26, 2006
9.00.21532005.90.2153.0918222 Cumulative hotfix package (build 2153) for SQL Server 2005 is availableSeptember 14, 2006
9.00.21532005.90.2153.0919224 FIX: You may receive an error message when you install the cumulative hotfix package (build 2153) for SQL Server 2005May 23, 2006
9.00.20502005.90.2050.0932555 FIX: A script task or a script component may not run correctly when you run an SSIS package in SQL Server 2005 build 2047July 11, 2007
9.00.20472005.90.2047.0SQL Server 2005 Service Pack 1 (SP1)April 18, 2006
9.00.20402005.90.2040.0SQL Server 2005 Service Pack 1 (SP1) CTP March 2006March 12, 2006
9.00.20292005.90.2029.0SLQ Server 2005 Service Pack 1 (SP1) Beta
9.00.15612005.90.1561.0932556 FIX: A script task or a script component may not run correctly when you run an SSIS package in SQL Server 2005 build 1500 and later buildsJuly 11, 2007
9.00.15582005.90.1558.0926493 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”January 4, 2007
9.00.15542005.90.1554.0926292 FIX: When you query through a view that uses the ORDER BY clause in SQL Server 2005, the result is still returned in random orderJune 26, 2007
9.00.15512005.90.1551.0922527 FIX: Error message when you schedule some SQL Server 2005 Integration Services packages to run as jobs: “Package <PackageName> has been cancelled”January 22, 2007
9.00.15512005.90.1551.0922804 FIX: After you detach a Microsoft SQL Server 2005 database that resides on network-attached storage, you cannot reattach the SQL Server databaseNovember 22, 2006
9.00.15502005.90.1550.0917887 FIX: The value of the automatic growth increment of a database file may be very large in SQL Server 2005July 26, 2006
9.00.15502005.90.1550.0921106 FIX: You receive an error message when you try to create a differential database backup in SQL Server 2005November 22, 2006
9.00.15472005.90.1547.0918276 FIX: You notice additional random trailing character in values when you retrieve the values from a fixed-size character column or a fixed-size binary column of a table in SQL Server 2005November 20, 2006
9.00.15452005.90.1545.0917905 FIX: SQL Server 2005 performance may be slower than SQL Server 2000 performance when you use an API server cursorAugust 14, 2006
9.00.15412005.90.1541.0917888 FIX: Error message when you use a server-side cursor to run a large complex query in SQL Server 2005: “Error: 8623, Severity: 16, State: 1 The query processor ran out of internal resources”November 22, 2006
9.00.15412005.90.1541.0917971 FIX: You may receive more than 100,000 page faults when you try to back up a SQL Server 2005 database that contains hundreds of files and file groupsNovember 22, 2006
9.00.15392005.90.1539.0917738 FIX: SQL Server 2005 system performance may be slow when you use a keyset-driven cursor to execute a FETCH statementAugust 11, 2006
9.00.15382005.90.1538.0917824 FIX: The SQL Server 2005 SqlCommandBuilder.DeriveParameters method returns an exception when the input parameter is a XML parameter that has an associated XSD from an SQL schemaJuly 26, 2006
9.00.15362005.90.1536.0917016 FIX: The monitor server does not monitor all primary servers and secondary servers when you configure log shipping in SQL Server 2005July 26, 2006
9.00.15342005.90.1534.0916706 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 2005May 15, 2007
9.00.15332005.90.1533.0916086 FIX: Errors may be generated in the tempdb database when you create and then drop many temporary tables in SQL Server 2005July 26, 2006
9.00.15322005.90.1532.0916046 FIX: Indexes may grow very large when you insert a row into a table and then update the same row in SQL Server 2005January 9, 2007
9.00.15312005.90.1531.0915918 FIX: The internal deadlock monitor may not detect a deadlock between two or more sessions in SQL Server 2005July 26, 2006
9.00.15282005.90.1528.0915309 FIX: When you start a merge agent, synchronization between the subscriber and the publisher takes a long time to be completed in SQL Server 2005January 15, 2007
9.00.15282005.90.1528.0915308 FIX: The CPU usage of the server reaches 100% when many DML activities occur in SQL Server 2005January 4, 2007
9.00.15282005.90.1528.0915307 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 2005January 11, 2007
9.00.15282005.90.1528.0915306 FIX: The merge agent fails and a “permission denied” error message is logged when you synchronize a SQL Server 2005-based merge publicationJanuary 8, 2007
9.00.15282005.90.1528.0915112 FIX: Error message when an ADO.NET-connected application tries to reuse a connection from the connection pool in SQL Server 2005: “The request failed to run because the batch is aborted”July 26, 2006
9.00.15192005.90.1519.0913494 FIX: The merge agent does not use a specified custom user update to handle conflicting UPDATE statements in SQL Server 2005January 20, 2007
9.00.15182005.90.1518.0913941 FIX: A SQL Server login may have more permissions when you log on to an instance of SQL Server 2005September 22, 2006
9.00.15182005.90.1518.0912472 FIX: An incorrect result may appear in the subscribing database when you set database mirroring for a database and database failover occurs in SQL Server 2005July 26, 2006
9.00.15182005.90.1518.0913371 FIX: You may receive error messages when you use the sp_cursoropen statement to open a cursor on a user-defined stored procedure in SQL Server 2005July 26, 2006
9.00.15142005.90.1514.0912471 FIX: The replication on the server does not work any longer when you manually fail over databases in SQL Server 2005July 26, 2006
9.00.15032005.90.1503.0911662 FIX: You may receive an access violation error message when you run a SELECT query in SQL Server 2005July 26, 2006
9.00.15022005.90.1502.0915793 FIX: You cannot restore the log backups on the mirror server after you remove database mirroring for the mirror database in SQL Server 2005July 26, 2006
9.00.15002005.90.1500.0910416 FIX: Error message when you run certain queries or certain stored procedures in SQL Server 2005: “A severe error occurred on the current command”June 1, 2006
9.00.14062005.90.1406.0932557 FIX: A script task or a script component may not run correctly when you run an SSIS package in SQL Server 2005 build 1399July 11, 2007
9.00.13992005.90.1399.0SQL Server 2005 RTMNovember 7, 2005

 

Note: RTM stands for release to market edition, which is the first supported version of SQL Server 2005, and SP stands for service pack. All SQL Server service packs and hotfixes are cumulative, meaning that each new service pack and hotfixes contains all the fixes that are included with previous service packs, hotfixes and new fixes issues.

Please use comment section, if you find build that is not listed here.

Rate

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

Share

Share

Rate

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

Related content

Technical Article

Database Mirroring FAQ: Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup?

Question: Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup? This question was sent to me via email. My reply follows. Can a 2008 SQL instance be used as the witness for a 2005 database mirroring setup? Databases to be mirrored are currently running on 2005 SQL instances but will be upgraded to 2008 SQL in the near future.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2009-02-23

1,567 reads

Technical Article

Networking - Part 4

You may want to read Part 1 , Part 2 , and Part 3 before continuing. This time around I'd like to talk about social networking. We'll start with social networking. Facebook, MySpace, and Twitter are all good examples of using technology to let...

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2009-02-17

1,530 reads

Technical Article

Speaking at Community Events - More Thoughts

Last week I posted Speaking at Community Events - Time to Raise the Bar?, a first cut at talking about to what degree we should require experience for speakers at events like SQLSaturday as well as when it might be appropriate to add additional focus/limitations on the presentations that are accepted. I've got a few more thoughts on the topic this week, and I look forward to your comments.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2009-02-13

360 reads