All Topics

How-to articles - SQL Server 2005

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.
FIX: Reorder outer joins with filter criteria before non-selective joins and outer joins
If you submit a query that contains at least one outer join that has a filter condition in the WHERE clause on the inner table of the outer join (for example, a filter condition on the right table of a left outer join, or the left table of a right...

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.
FIX: An ongoing MS DTC transaction is orphaned in SQL Server 2005
Fixes an issue in which an MS DTC transaction is orphaned after you enlist some transactions from some connections to the MS DTC transaction and then log off these connections in SQL Server 2005.
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.