Need help on Distributed Transaction

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

Need help on Distributed Transaction

Author

Topic

Delinda
Constraint Violating Yak Guru

315 Posts

Posted - 2010-12-28 : 10:10:53

Without Linked Server is setup, and
Based on article on [url]http://msdn.microsoft.com/en-us/library/ms188386(v=SQL.90).aspx
[/url]

I was run T/SQL as follow,


SET XACT_ABORT ON
BEGIN DISTRIBUTED TRANSACTION;
-- Insert
insert into tPurchaseOrder values('1926','Purchase Order');

-- Insert
insert into [MAFC-SVR1\NAV1].st3db.dbo.tDeliveryNote(no,remark) values('4475','1926~Purchare Order');
COMMIT TRANSACTION;
GO

The error was shown,
Could not find server 'MAFC-SVR1\NAV1' in sys.servers. Verify that the correct server name was specified. If necessary, execute the stored procedure sp_addlinkedserver to add the server to sys.servers.

Looking for technical advice.

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2010-12-28 : 11:28:10

You need to add MAFC-SVR1\NAV1 as a linked server to do it this way.

Delinda
Constraint Violating Yak Guru

315 Posts

Posted - 2010-12-28 : 20:09:21

Sir,

Did we've a choice to setup another technical things instead of Linked Server?

I'm heard, Linked Server have a potential to interrupt a performance

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2010-12-28 : 20:31:50

It should not interrupt unless you have network problems. You can use OPENQUERY, but that is still a linked server.

Alternatively, you can replicate the data, then query it locally.

Delinda
Constraint Violating Yak Guru

315 Posts

Posted - 2010-12-28 : 22:45:51

Server to server, my network bandwidth is 2GB. I can say, our network is stabble.

It's mean, Linked Server looks suitable to used.

Are you agree with me sir?

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2010-12-29 : 11:59:13

Yes

Delinda
Constraint Violating Yak Guru

315 Posts

Posted - 2010-12-30 : 09:06:57

tq sir.

your answer is my inspiration

russell
Pyro-ma-ni-yak

5072 Posts

Posted - 2010-12-30 : 12:24:40

Welcome