SQL Server 2005 Version Numbers

Understanding SQL Server 2005 Version Numbers

Microsoft SQL Server 2005, despite being retired from support, remains in use in some legacy systems. Understanding the nuances of its version numbers is critical for administrators managing older environments. SQL Server 2005 version numbers indicate the specific build of the server and provide insight into the patches or service packs applied.

In this blog post, we’ll explore what SQL 2005 version numbers signify, how to find them, and why they’re essential for ensuring compatibility and stability in older systems.

What Are SQL 2005 Version Numbers?

SQL 2005 version numbers are unique identifiers for each build or update of SQL Server 2005. They consist of four segments, such as 9.00.5000.00. Each segment represents a specific aspect of the version:

  • Major Version (9): Identifies the main SQL Server version (SQL Server 2005).
  • Minor Version (00): Generally remains 00 for SQL Server 2005.
  • Build Number (5000): Reflects the specific service pack or cumulative update.
  • Revision (00): Typically used for hotfixes or other minor updates.

For example, the version number 9.00.5000.00 indicates SQL Server 2005 Service Pack 4 (SP4), which is the final supported build for SQL Server 2005.

Why SQL 2005 Version Numbers Matter

Understanding SQL 2005 version numbers is crucial for:

  1. Compatibility: Applications and drivers may require specific builds for proper functionality.
  2. Troubleshooting: Identifying the build helps diagnose bugs or issues specific to certain versions.
  3. Security: Knowing your version ensures you’re running the latest patches and fixes available for SQL Server 2005.

While Microsoft no longer supports SQL Server 2005, ensuring you’re on the final Service Pack (SP4) minimizes vulnerabilities and improves stability in legacy systems.

How to Find SQL 2005 Version Numbers

You can determine the version number of your SQL Server 2005 instance using the following methods:

1. Using T-SQL

Run the following query in SQL Server Management Studio (SSMS):

SELECT @@VERSION AS VersionInfo;

This command returns the version number along with additional details, such as the operating system.

2. Using SQL Server Error Logs

Check the first few lines of the SQL Server error log. The version number and build information are typically listed there.

3. Viewing in SSMS

In SSMS, connect to your SQL Server 2005 instance, right-click the server in Object Explorer, and select Properties. The version number is displayed on the General page.

SQL Server 2005 Version Numbers

Common SQL 2005 Version Numbers

Here are some of the key SQL 2005 version numbers and their corresponding builds:

Version NumberDescription
9.00.1399.06RTM (Release to Manufacturing) version.
9.00.2047.00Service Pack 1 (SP1).
9.00.3042.00Service Pack 2 (SP2).
9.00.4035.00Service Pack 3 (SP3).
9.00.5000.00Service Pack 4 (SP4).

If your SQL Server 2005 version number is lower than 9.00.5000.00, it’s recommended to apply SP4 to ensure the most stable and secure configuration for your legacy environment.

Challenges of SQL Server 2005

Although understanding SQL 2005 version numbers can help you manage your instance effectively, using SQL Server 2005 presents several challenges:

  1. No Official Support: SQL Server 2005 reached the end of extended support in April 2016, meaning no new patches or updates are available.
  2. Security Risks: Running an unsupported version exposes your environment to potential vulnerabilities.
  3. Performance Limitations: Modern hardware and software may not perform optimally with SQL Server 2005.

For these reasons, migrating to a supported version of SQL Server is highly recommended. Tools like Database Health Monitor can assist with pre-migration analysis to ensure a smooth upgrade.

Next Steps for SQL Server 2005 Users

If you’re still using SQL Server 2005, consider these actions:

  1. Document Your Version: Use the SQL 2005 version numbers discussed above to verify your build.
  2. Apply Final Updates: If you’re not already on SP4, update your instance to 9.00.5000.00.
  3. Plan an Upgrade: Evaluate newer versions of SQL Server, such as SQL Server 2019 or 2022, to benefit from improved performance, features, and security.

Conclusion

SQL 2005 version numbers provide valuable insight into the state of your SQL Server 2005 instance. By understanding and identifying the version number, you can ensure compatibility, address performance issues, and prepare for the future.

While SQL Server 2005 served businesses well during its time, transitioning to a modern version is critical for staying secure and efficient. If you need assistance evaluating or upgrading your environment, contact Stedman Solutions for expert guidance.

You can also view this easily in Database Health Monitor from the Performance Dashboard.

SQL Server 2005 Version Numbers
Below is a detailed table listing the release dates, build numbers, and descriptions for SQL Server 2005 updates. This can serve as a reference for administrators maintaining legacy SQL Server 2005 environments.

Release Date Build KB / Description
10/09/20129.0.53242716427 MS12-070: Description of the security update for SQL Server 2005 Service Pack 4 QFE
10/24/20119.0.52962615425 FIX: “Msg 7359” error when a view uses another view in SQL Server 2005 if the schema version of a remote table is updated
05/21/20129.0.52952598903 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 R2
08/10/20119.0.52942572407 FIX: Error 5180 when you use the ONLINE option to rebuild an index in SQL Server 2005
06/14/20119.0.52922494123 MS11-049: Description of the security update for SQL Server 2005 Service Pack 4 QFE: June 14, 2011
03/22/20119.0.52662507769 Cumulative update package 3 (CU3) for SQL Server 2005 Service Pack 4
02/22/20119.0.52592489409 Cumulative update package 2 (CU2) for SQL Server 2005 Service Pack 4
12/24/20109.0.52542464079 Cumulative update package 1 (CU1) for SQL Server 2005 Service Pack 4
10/09/20129.0.5069Microsoft Security Bulletin MS12-070
06/14/20119.0.50572494120 MS11-049: Description of the security update for SQL Server 2005 Service Pack 4 GDR: June 14, 2011
12/17/20109.0.50002463332 SQL Server 2005 Service Pack 4 (SP4)  Latest SP
11/03/20109.0.4912SQL Server 2005 Service Pack 4 (SP4) – Customer Technology Preview (CTP)  Beta
05/21/20129.0.43422598903 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 R2
06/14/20119.0.43402494112 MS11-049: Description of the security update for SQL Server 2005 Service Pack 3 QFE: June 14, 2011
03/22/20119.0.43252507766 Cumulative update package 15 (CU15) for SQL Server 2005 Service Pack 3
02/21/20119.0.43172489375 Cumulative update package 14 (CU14) for SQL Server 2005 Service Pack 3
12/23/20109.0.43152438344 Cumulative update package 13 (CU13) for SQL Server 2005 Service Pack 3
10/18/20109.0.43112345449 Cumulative update package 12 (CU12) for SQL Server 2005 Service Pack 3
08/16/20109.0.43092258854 Cumulative update package 11 (CU11) for SQL Server 2005 Service Pack 3
06/23/20109.0.4305983329 Cumulative update package 10 (CU10) for SQL Server 2005 Service Pack 3
04/19/20109.0.4294980176 Cumulative update package 9 (CU9) for SQL Server 2005 Service Pack 3
02/16/20109.0.4285978915 Cumulative update package 8 (CU8) for SQL Server 2005 Service Pack 3
12/21/20099.0.4273976951 Cumulative update package 7 (CU7) for SQL Server 2005 Service Pack 3
12/21/20099.0.4268977151 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”
10/19/20099.0.4266974648 Cumulative update package 6 (CU6) for SQL Server 2005 Service Pack 3
10/13/20099.0.4262970894 MS09-062: Description of the security update for SQL Server 2005 Service Pack 3 QFE: October 13, 2009
08/17/20099.0.4230972511 Cumulative update package 5 (CU5) for SQL Server 2005 Service Pack 3
06/16/20099.0.4226970279 Cumulative update package 4 (CU4) for SQL Server 2005 Service Pack 3
06/16/20099.0.4224971409 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”
04/20/20099.0.4220967909 Cumulative update package 3 (CU3) for SQL Server 2005 Service Pack 3
04/20/20099.0.4216967101 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 2005
02/17/20099.0.4211961930 Cumulative update package 2 (CU2) for SQL Server 2005 Service Pack 3
12/20/20089.0.4207959195 Cumulative update package 1 (CU1) for SQL Server 2005 Service Pack 3
06/14/20119.0.40602494113 MS11-049: Description of the security update for SQL Server 2005 Service Pack 3 GDR: June 14, 2011
10/13/20099.0.4053970892 MS09-062: Description of the security update for SQL Server 2005 Service Pack 3 GDR: October 13, 2009
12/15/20089.0.4035955706 SQL Server 2005 Service Pack 3 (SP3)
10/27/20089.0.4028SQL Server 2005 Service Pack 3 (SP3) – CTP  Beta
12/21/20099.0.3356976952 Cumulative update package 17 (CU17) for SQL Server 2005 Service Pack 2
10/19/20099.0.3355974647 Cumulative update package 16 (CU16) for SQL Server 2005 Service Pack 2
10/13/20099.0.3353970896 MS09-062: Description of the security update for SQL Server 2005 Service Pack 2 QFE: October 13, 2009
08/18/20099.0.3330972510 Cumulative update package 15 (CU15) for SQL Server 2005 Service Pack 2
06/16/20099.0.3328970278 Cumulative update package 14 (CU14) for SQL Server 2005 Service Pack 2
04/20/20099.0.3325967908 Cumulative update package 13 (CU13) for SQL Server 2005 Service Pack 2
04/01/20099.0.3320969142 FIX: Error message when you run the DBCC CHECKDB statement on a database in SQL Server 2005: “Unable to deallocate a kept page”
04/20/20099.0.3318967199 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 provider
02/17/20099.0.3315962970 Cumulative update package 12 (CU12) for SQL Server 2005 Service Pack 2
02/10/20099.0.3310960090 MS09-004: Description of the security update for SQL Server 2005 QFE: February 10, 2009
12/16/20089.0.3301958735 Cumulative update package 11 (CU11) for SQL Server 2005 Service Pack 2
10/20/20089.0.3294956854 Cumulative update package 10 (CU10) for SQL Server 2005 Service Pack 2
06/16/20089.0.3282953752 Cumulative update package 9 (CU9) for SQL Server 2005 Service Pack 2
07/14/20089.0.3260954950 FIX: Error message when you run a distributed query in SQL Server 2005: “OLE DB provider ‘SQLNCLI’ for linked server ‘‘ returned message ‘No transaction is active'”
08/14/20089.0.3259954831 FIX: In SQL Server 2005, the session that runs the TRUNCATE TABLE statement may stop responding, and you cannot end the session
07/14/20089.0.3259954669 FIX: An ongoing MS DTC transaction is orphaned in SQL Server 2005
06/18/20089.0.3257951217 Cumulative update package 8 (CU8) for SQL Server 2005 Service Pack 2
05/23/20089.0.3246952233 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
06/03/20089.0.3244952330 FIX: The Replication Log Reader Agent may fail intermittently when a transactional replication synchronizes data in SQL Server 2005
05/21/20089.0.3240951204 FIX: An access violation occurs when you update a table through a view by using a cursor in SQL Server 2005
04/17/20089.0.3239949095 Cumulative update package 7 (CU7) for SQL Server 2005 Service Pack 2
03/19/20089.0.3232949959 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.'”
03/18/20089.0.3231949595 FIX: Error message when you run a query that uses a join condition in SQL Server 2005: “Non-yielding Scheduler”
03/14/20089.0.3231949687 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”
03/07/20089.0.3230949199 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”
02/19/20089.0.3228946608 Cumulative update package 6 (CU6) for SQL Server 2005 Service Pack 2
02/04/20089.0.3224947463 FIX: A stored procedure cannot finish its execution in SQL Server 2005
01/31/20089.0.3221942908 FIX: The change may be undone during the later synchronizations when you change an article on the subscriber in SQL Server 2005
01/11/20089.0.3221945443 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
01/10/20089.0.3221945916 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”
01/09/20089.0.3221945442 FIX: You cannot cancel the query execution immediately if you open a fast forward-only cursor for the query in SQL Server 2005
12/18/20079.0.3215943656 Cumulative update package 5 (CU5) for SQL Server 2005 Service Pack 2
11/21/20079.0.3208944902 FIX: A federated database server stops responding when you run parallel queries on a multiprocessor computer that uses NUMA architecture in SQL Server 2005
12/11/20079.0.3206944677 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 2005
10/17/20079.0.3200941450 Cumulative update package 4 (CU4) for SQL Server 2005 Service Pack 2
09/24/20079.0.3194940933 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 2005
08/29/20079.0.3186940943 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 2005
08/24/20079.0.3186940378 FIX: A cursor uses the incorrect transaction isolation level after you change the transaction isolation level for the cursor in SQL Server 2005
08/23/20079.0.3186940269 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”
08/22/20079.0.3186940945 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 2005
08/21/20079.0.3186940937 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'”
08/20/20079.0.3186940379 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 ‘‘ exceeded retry count”
08/20/20079.0.3186940375 FIX: Error message when you use the Copy Database Wizard to move a database from SQL Server 2000 to SQL Server 2005
08/20/20079.0.3186937100 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”
08/20/20079.0.3186940126 FIX: Error 9003 is logged in the SQL Server error log file when you use log shipping in SQL Server 2005
08/17/20079.0.3186938363 FIX: Data is not replicated to a subscriber in a different partition by using parameterized row filters in SQL Server 2005
08/17/20079.0.3186940935 FIX: Error message when you run a query that is associated with a parallel execution plan in SQL Server 2005: “SQL Server Assertion: File: , line=10850 Failed Assertion = ‘GetLocalLockPartition () == xactLockInfo->GetLocalLockPartition ()'”
08/17/20079.0.3186940221 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 returned message”
08/17/20079.0.3186940942 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”
08/13/20079.0.3186940384 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 installed
08/13/20079.0.3186940281 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 2005
08/10/20079.0.3186940545 FIX: The performance of insert operations against a table that contains an identity column may be slow in SQL Server 2005
08/08/20079.0.3186940210 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”
08/23/20079.0.3186939537 Cumulative update package 3 (CU3) for SQL Server 2005 Service Pack 2
08/03/20079.0.3182940128 FIX: You receive error 8623 when you run a complex query in SQL Server 2005
07/30/20079.0.3179938243 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.”
08/22/20079.0.3178938086 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 2005
08/22/20079.0.3177939285 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”
08/20/20079.0.3177939562 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”
08/09/20079.0.3177939563 FIX: Error message when you synchronize a merge replication in Microsoft SQL Server 2005: “MSmerge_del_, Line 42 String or binary data would be truncated”
08/20/20079.0.3175936534 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””
08/01/20079.0.3175938671 FIX: The Distribution Agent may skip some rows when you configure a transactional replication that uses the “-SkipErrors” parameter in SQL Server 2005
07/10/20079.0.3175936488 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 SP2
06/29/20079.0.3175938825 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
06/28/20079.0.3175936305 Cumulative update package 2 (CU2 build 3175) for SQL Server 2005 Service Pack 2 is available
07/16/20079.0.3171937745 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
06/19/20079.0.3169937033 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”
05/25/20079.0.3169937041 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
06/11/20079.0.3166936185 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
07/16/20079.0.3166934734 FIX: A database is marked as suspect when you update a table that contains a nonclustered index in SQL Server 2005
09/24/20079.0.3161935789 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 join
06/04/20079.0.3161934706 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”
05/09/20079.0.3161933724 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
04/16/20079.0.3161935356 Cumulative update package (CU1 build 3161) for SQL Server 2005 Service Pack 2 is available
04/03/20079.0.3159934459 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
04/25/20079.0.3156934226 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)”
06/13/20079.0.3155933808 FIX: Error message when you run a query that contains nested FOR XML clauses in SQL Server 2005: “The XML data type is damaged”
06/12/20079.0.3155933499 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”
05/15/20079.0.3155933766 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)”
04/25/20079.0.3155933549 FIX: You may receive an access violation when you perform a bulk copy operation in SQL Server 2005
04/25/20079.0.3154934188 FIX: The Distribution Agent does not deliver commands to the Subscriber even if the Distribution Agent is running in SQL Server 2005
04/25/20079.0.3154934109 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
04/25/20079.0.3154934106 FIX: SQL Server 2005 database engine generates failed assertion errors when you use the Replication Monitor to monitor the distribution database
04/16/20079.0.3153933564 FIX: A gradual increase in memory consumption for the USERSTORE_TOKENPERM cache store occurs in SQL Server 2005
03/07/20079.0.3152933097 Cumulative hotfix package (build 3152) for SQL Server 2005 Service Pack 2 is available
10/13/20099.0.3080970895 MS09-062: Description of the security update for GDI+ for SQL Server 2005 Service Pack 2 GDR: October 13, 2009
02/10/20099.0.3077960089 MS09-004: Description of the security update for SQL Server 2005 GDR: February 10, 2009
09/09/20089.0.3073954606 MS08-052: Description of the security update for GDI+ for SQL Server 2005 Service Pack 2 GDR: September 9, 2008
08/05/20089.0.3068941203 MS08-040: Vulnerabilities in Microsoft SQL Server could allow elevation of privilege
01/02/20089.0.3054934458 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
03/07/20079.0.3050933508 Microsoft SQL Server 2005 Service Pack 2 issue: Cleanup tasks run at different intervals than intended
02/19/20079.0.3042SQL Server 2005 Service Pack 2 (SP2)
12/19/20069.0.3033SQL Server 2005 Service Pack 2 (SP2) – CTP December 2006  Beta
11/06/20069.0.3027SQL Server 2005 Service Pack 2 (SP2) – CTP November 2006  Beta
02/14/20079.0.3026929376 FIX: A “17187” error message may be logged in the Errorlog file when an instance of SQL Server 2005 is under a heavy load
09/24/20079.0.2239940961 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 2005
09/24/20079.0.2237940719 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 2005
07/29/20079.0.2236940287 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.)'”
07/26/20079.0.2236940286 FIX: A Service Broker endpoint stops passing messages in a database mirroring session of SQL Server 2005
06/20/20079.0.2234937343 FIX: SQL Server 2005 stops and then restarts unexpectedly and errors occur in the tempdb database
06/18/20079.0.2233937545 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”
06/12/20079.0.2233933499 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”
06/05/20079.0.2233937544 FIX: You may receive error 3456 when you try to restore a transaction log for a SQL Server 2005 database
06/19/20079.0.2232937277 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
11/06/20079.0.2231934812 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 2005
09/20/20079.0.2230936179 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”
06/11/20079.0.2229935446 FIX: You receive error messages when you use the BULK INSERT statement in SQL Server 2005 to import data in bulk
06/26/20079.0.2227933265 FIX: You may receive error 1203 when you run an INSERT statement against a table that has an identity column in SQL Server 2005
06/22/20079.0.2226934065 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”
06/22/20079.0.2226933762 FIX: You receive error 18815 when the Log Reader Agent runs for a transactional publication in SQL Server 2005
06/18/20079.0.2223932393 FIX: You may experience poor performance after you install SQL Server 2005 Service Pack 1
07/11/20079.0.2221931593 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 builds
04/25/20079.0.2219932115 FIX: The ghost row clean-up thread does not remove ghost rows on some data files of a database in SQL Server 2005
04/25/20079.0.2218931843 FIX: SQL Server 2005 does not reclaim the disk space that is allocated to the temporary table if the stored procedure is stopped
05/15/20079.0.2216931821 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 installed
02/19/20079.0.2214930505 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”
02/13/20079.0.2214929240 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
02/20/20079.0.2211930284 FIX: You receive error 1456 when you try to add a witness to a DBM session in SQL Server 2005
02/14/20079.0.2211930283 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
02/07/20079.0.2209929278 FIX: SQL Server 2005 may not perform histogram amendments when you use trace flags 2389 and 2390
01/09/20079.0.2208929179 FIX: A memory leak may occur every time that you synchronize a SQL Server Mobile subscriber in SQL Server 2005
12/19/20069.0.2207928394 FIX: The changes are not reflected in the publication database after you reinitialize the subscriptions in SQL Server 2005
12/19/20069.0.2207928372 FIX: Error message when you use a synonym for a stored procedure in SQL Server 2005: “A severe error occurred on the current command”
01/02/20079.0.2207928789 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”
02/01/20079.0.2206928083 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
01/12/20079.0.2206928537 FIX: The full-text index population for the indexed view is very slow in SQL Server 2005
01/02/20079.0.2206926493 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”
12/13/20069.0.2206928539 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 2005
02/16/20079.0.2202927643 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
01/10/20079.0.2201927289 FIX: Updates to the SQL Server Mobile subscriber may not be reflected in the SQL Server 2005 merge publication
02/21/20079.0.2198926613 FIX: You may receive incorrect results when you query a table that is published in a transactional replication in SQL Server 2005
02/20/20079.0.2198926106 FIX: You receive an error message when you use the Print Preview option on a large report in SQL Server 2005 Reporting Services
02/02/20079.0.2198924807 FIX: The restore operation may take a long time to finish when you restore a database in SQL Server 2005
12/13/20069.0.2198924264 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 Studio
01/04/20079.0.2198926612 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
11/16/20069.0.2198926773 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”
11/28/20069.0.2198926611 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 2005
12/13/20069.0.2198924808 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 2005
01/02/20079.0.2198925277 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
11/10/20069.0.2196926285 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”
12/05/20069.0.2196926335 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”
12/19/20069.0.2195926240 FIX: SQL Server 2005 may stop responding when you use the SqlBulkCopy class to import data from another data source
10/20/20069.0.2194925744 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”
09/29/20069.0.2192924954 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”
10/05/20069.0.2192925335 FIX: Error message when you use a label after a Transact-SQL query in SQL Server 2005: “Incorrect syntax near ‘X'”
12/06/20069.0.2191925135 FIX: An empty string is replicated as a NULL value when you synchronize a table to a SQL Server 2005 Compact Edition subscriber
10/16/20069.0.2190925227 FIX: Error message when you call the SQLTables function against an instance of SQL Server 2005: “Invalid cursor state (0)”
09/22/20069.0.2189925153 FIX: You may receive different date values for each row when you use the getdate function within a case statement in SQL Server 2005
09/22/20069.0.2187923849 FIX: When you run a query that references a partitioned table in SQL Server 2005, query performance may decrease
02/19/20079.0.2181923605 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
10/04/20069.0.2181923624 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”
02/12/20079.0.2176922594 FIX: Error message when you use SQL Server 2005: “High priority system task thread Operating system error Exception 0xAE encountered”
09/06/20069.0.2176923296 FIX: Log Reader Agent fails, and an assertion error message is logged when you use transactional replication in SQL Server 2005
08/08/20069.0.2175921395 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 Services
08/14/20069.0.2175917905 FIX: SQL Server 2005 performance may be slower than SQL Server 2000 performance when you use an API server cursor
08/30/20069.0.2175922578 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 log
12/14/20069.0.2175922438 FIX: A query may take a long time to compile when the query contains several JOIN clauses against a SQL Server 2005 database
12/18/20069.0.2175921536 FIX: A handled access violation may occur in the CValSwitch::GetDataX function when you run a complex query in SQL Server 2005
07/25/20069.0.2174922063 FIX: You may notice a large increase in compile time when you enable trace flags 2389 and 2390 in SQL Server 2005 Service Pack 1
08/09/20069.0.2167920974 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 80
02/08/20079.0.2164919243 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
09/19/20069.0.2164920346 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 predicate
09/19/20069.0.2164920347 FIX: The SQL Server 2005 query optimizer may incorrectly estimate the cardinality for a query that has a predicate that contains an index union alternative
10/26/20069.0.2164919929 FIX: Error message when the Replication Merge Agent runs in SQL Server 2005: “Source: MSSQL_REPL, Error number: MSSQL_REPL-2147199402”
08/29/20069.0.2164921003 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 log
09/26/20069.0.2164920206 FIX: System performance may be slow when an application submits many queries against a SQL Server 2005 database that uses simple parameterization
09/06/20069.0.2164918882 FIX: A query plan is not cached in SQL Server 2005 when the text of the hint is a large object
07/26/20069.0.2164919636 FIX: Memory usage of the compiled query plan may unexpectedly increase in SQL Server 2005
08/09/20069.0.2164919775 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 2005
07/26/20069.0.2156919611 FIX: The value of the automatic growth increment of a database file may be very large in SQL Server 2005 with Service Pack 1
09/14/20069.0.2153918222 Cumulative hotfix package (build 2153) for SQL Server 2005 is available
05/23/20069.0.2153919224 FIX: You may receive an error message when you install the cumulative hotfix package (build 2153) for SQL Server 2005
07/11/20079.0.2050932555 FIX: A script task or a script component may not run correctly when you run an SSIS package in SQL Server 2005 build 2047
04/18/20069.0.2047SQL Server 2005 Service Pack 1 (SP1)
03/12/20069.0.2040SQL Server 2005 Service Pack 1 (SP1) CTP March 2006  Beta
01/00/19009.0.2029SQL Server 2005 Service Pack 1 (SP1) Beta  Beta
07/11/20079.0.1561932556 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 builds
01/04/20079.0.1558926493 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”
06/26/20079.0.1554926292 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
01/22/20079.0.1551922527 FIX: Error message when you schedule some SQL Server 2005 Integration Services packages to run as jobs: “Package has been cancelled”
11/22/20069.0.1551922804 FIX: After you detach a Microsoft SQL Server 2005 database that resides on network-attached storage, you cannot reattach the SQL Server database
07/26/20069.0.1550917887 FIX: The value of the automatic growth increment of a database file may be very large in SQL Server 2005
11/22/20069.0.1550921106 FIX: You receive an error message when you try to create a differential database backup in SQL Server 2005
11/20/20069.0.1547918276 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 2005
08/14/20069.0.1545917905 FIX: SQL Server 2005 performance may be slower than SQL Server 2000 performance when you use an API server cursor
11/22/20069.0.1541917888 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”
11/22/20069.0.1541917971 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 groups
08/11/20069.0.1539917738 FIX: SQL Server 2005 system performance may be slow when you use a keyset-driven cursor to execute a FETCH statement
07/26/20069.0.1538917824 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 schema
07/26/20069.0.1536917016 FIX: The monitor server does not monitor all primary servers and secondary servers when you configure log shipping in SQL Server 2005
05/15/20079.0.1534916706 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
07/26/20069.0.1533916086 FIX: Errors may be generated in the tempdb database when you create and then drop many temporary tables in SQL Server 2005
01/09/20079.0.1532916046 FIX: Indexes may grow very large when you insert a row into a table and then update the same row in SQL Server 2005
07/26/20069.0.1531915918 FIX: The internal deadlock monitor may not detect a deadlock between two or more sessions in SQL Server 2005
01/15/20079.0.1528915309 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
01/04/20079.0.1528915308 FIX: The CPU usage of the server reaches 100% when many DML activities occur in SQL Server 2005
01/11/20079.0.1528915307 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
01/08/20079.0.1528915306 FIX: The merge agent fails and a “permission denied” error message is logged when you synchronize a SQL Server 2005-based merge publication
07/26/20069.0.1528915112 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”
01/20/20079.0.1519913494 FIX: The merge agent does not use a specified custom user update to handle conflicting UPDATE statements in SQL Server 2005
09/22/20069.0.1518913941 FIX: A SQL Server login may have more permissions when you log on to an instance of SQL Server 2005
07/26/20069.0.1518912472 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 2005
07/26/20069.0.1518913371 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 2005
07/26/20069.0.1514912471 FIX: The replication on the server does not work any longer when you manually fail over databases in SQL Server 2005
07/26/20069.0.1503911662 FIX: You may receive an access violation error message when you run a SELECT query in SQL Server 2005
07/26/20069.0.1502915793 FIX: You cannot restore the log backups on the mirror server after you remove database mirroring for the mirror database in SQL Server 2005
06/01/20069.0.1500910416 FIX: Error message when you run certain queries or certain stored procedures in SQL Server 2005: “A severe error occurred on the current command”
07/11/20079.0.1406932557 FIX: A script task or a script component may not run correctly when you run an SSIS package in SQL Server 2005 build 1399
11/07/20059.0.1399SQL Server 2005 RTM  RTM

 

SQL Server Updates list

Other Related Links