Browse by Tags

FIX: Error message when you run a stored procedure that references a linked server that is linked to the local server itself in SQL Server 2005: "Transaction context in use by another session"

Published 4 February 8 3:1 AM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise X64 Edition Notification Contents: New and All Modifications FIX: Error message when you run a stored procedure that references a linked server...

Filed under: sql server, kba, x64, 2005, transactions, context, linked server

SQL Server error - The linked server has been created but failed a connection test. Do you want to keep the linked server?

Published 16 January 8 1:40 AM | SSQA.net

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...

Filed under: sql server, microsoft, error, kba, 2000, error log, 2005, stored procedure, linked server, aspfaq, issues

Performance is slow when you run a query in SQL Server 2005 that updates a table on a linked server and then joins the table to a table on the local server

Published 24 October 7 11:14 PM | SSQA.net

The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition & SQL Server 2005 Standard Edition Notification Contents: New and Major Modifications Performance is slow when you run a query...

Filed under: sql server, performance, kba, joins, slow, linked server