SqlServer-QA.net

Knowledge Sharing Network

Welcome to SqlServer-QA.net Sign in | Join | Help

Browse by Tags

FIX: An ongoing MS DTC transaction is orphaned in SQL Server 2005

The following pages were recently modified. Source: Knowledge BaseProduct: Microsoft SQL Server 2005 Enterprise X64 Edition & SQL Server 2005 Standard EditionNotification Contents: New and All Modifications FIX: An ongoing MS DTC transaction is orphaned in SQL Server 2005http://support.microsoft.com/kb/949075/en-US

Posted to SQL Server Knowledge Base articles (SSQA.net) (Weblog) by sqlmaster on May 15, 2008
SQL Server error - The linked server has been created but failed a connection test. Do you want to keep the linked server?

Linked Server errors, such as between SQL Server 2000 and 2005 versions are quite common in DBA-day life. When it goes wrong I would always refer (myself) and others to review HowDoI-PreventLinkedServerIssues resource from ASPFAQ site. Also the usual practice of checking of whether its a security issue to allow the logins, if so then goto ...

Posted to SQL Server Storage Engine & Tools (SSQA.net) (Weblog) by sqlmaster on January 16, 2008