SQL Server 2005 Solution Center

Top issues

FIX: You may receive an error message when you run Database Engine Tuning Advisor by using the dta command-prompt utility in SQL Server 2005
Fixes the problem that occurs when you run Database Engine Tuning Advisor from the command line in SQL Server 2005.
FIX: You receive error 1456 when you try to add a witness to a DBM session in SQL Server 2005
Fixes a problem that occurs in SQL Server 2005. When you try to add a witness to a DBM session, you receive error 1456.
Cumulative update package 9 for SQL Server 2005 Service Pack 2
Describes the cumulative update package for Microsoft SQL Server 2005 Service Pack 2.

Error message when you open SQL Server 2005 Books Online: "Microsoft Document Explorer cannot be shown because the specified help collection 'ms-help://MS.SQLCC.v9' is invalid"
Describes a problem that occurs when you uninstall a SQL Server 2005 Books Online installation on a computer where another language version is installed, and you receive an error message when you try to open the other installation.
The BizTalk host instance may recycle unexpectedly under high-load conditions in BizTalk Server 2006
Describes a problem in which you may receive any of several error messages. Resolution is provided.
FIX: You may receive an error message when you try to load data by using CLR functions in a Transact-SQL job in SQL Server 2005
FIX: Error message when you try to use CLR functions in a Transact-SQL job to load data in SQL Server 2005: "Error 563"