Re: Linked Server & XACT_ABORT

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Wayne Snyder (wayne.nospam.snyder_at_mariner-usa.com)
Date: 11/22/04 

Date: Mon, 22 Nov 2004 16:13:19 -0500

a.. If an application has a local transaction and the option
REMOTE_PROC_TRANSACTIONS is set ON, calling a remote stored procedure
escalates the local transaction to a distributed transaction.

This can be set via sp_configure I beleive... I have never tried this, but
perhaps it is worth a few minutes of your time.. 

-- 
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Paul" <Paul@discussions.microsoft.com> wrote in message
news:A2488655-A223-4C02-AAEF-33AD82485C53@microsoft.com...
>
> Is there anyway to set XACT_ABORT ON for a linked server?  We have a
linked
> server setup between SQL 2000 and DB2.  To use transactions we need to
turn
> XACT_ABORT on in every single stored procedure.  Is there a way to turn it
on
> at the linked server level?
>
> Thanks.
>
> Paul
>
>

Relevant Pages

  • Linked Server: Performance Issue with OpenQuery & SP best practices
    ... We are using the linked server feature of SQL Server 2000 to execute queries ... from the local database's stored procedure against the SQL Server database ... Please note that the schema of the remote database is different from the ...
    (microsoft.public.sqlserver.olap)
  • Re: ODBC in Stored Procedure
    ... I don't want to use linked server. ... OLE object that you could call from a stored procedure, ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ... Books Online for SQL Server 2005 at ...
    (comp.databases.ms-sqlserver)
  • Re: How to query two SQL Server instances
    ... SQL Server Programmer ... > I need to run a stored procedure, or make it simpler, to run a query to ... > the databases in head office? ... Then need to make it as linked server? ...
    (microsoft.public.sqlserver.programming)
  • Re: Linked server execution plans
    ... > Having a stored procedure on the linked server, ... > Vyas, MVP (SQL Server) ...
    (microsoft.public.sqlserver.server)
  • Linked Server and Verify Connection
    ... I am adding a linked server to another SQL server within a stored procedure. ... I need to verify the link was made before I start running any more code. ...
    (microsoft.public.sqlserver.mseq)