Saturday, February 11, 2012

About distributed trans

I have two Server. One is Local, another is Remote. Both Installed SQL Server 2000 at Server 2000.
I start MSDTC on both the local and the remote. The Remote SQL Server start MTS.

When I run the code forward, the error message '7391' will occur

begin distributed tran
select * from rmtdb.pubs.dbo.employee --rmtdb is a linked server
go

How to verify the OLE DB provider specified supports distributed transactions?
How can I do for this error message?
How can I reconfig the Local Server and the Remote?Make sure you have these settings before SP or code :

SET ANSI_DEFAULTS ON
SET ANSI_NULLS ON
SET ANSI_WARNINGS ON
SET XACT_ABORT ON

No comments:

Post a Comment