Wrox Programmer Forums
Go Back   Wrox Programmer Forums > SQL Server > SQL Server 2000 > SQL Server 2000
|
SQL Server 2000 General discussion of Microsoft SQL Server -- for topics that don't fit in one of the more specific SQL Server forums. version 2000 only. There's a new forum for SQL Server 2005.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the SQL Server 2000 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old July 19th, 2004, 02:24 AM
Authorized User
 
Join Date: Jun 2003
Posts: 13
Thanks: 0
Thanked 0 Times in 0 Posts
Default Linked Servers - Distributed Transaction

Hello,

I have setup two servers as linked servers. And when I execute the following query from server1, It is hanging and I am not getting any response.

begin distributed transaction
select * from server2.pubs.dbo.authors
rollback transaction

But, if I execute the same query with out a transaction (like below), it is displaying the results immediately.

select * from server2.pubs.dbo.authors


Any clues..why???

Thanks for your help.

Ram
 
Old July 20th, 2004, 09:01 AM
Authorized User
 
Join Date: Jul 2004
Posts: 66
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I'm not entirely sure, but it isn't really a transaction. It's just a select statement.
 
Old July 20th, 2004, 10:42 PM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 2,480
Thanks: 0
Thanked 1 Time in 1 Post
Default

Still that works for me. I don't see anything going wrong with both ways of usage. May be you can let that completely execute and see if that results in any errors, if at all you cancel the execution forcefully.

Cheers!

_________________________
- Vijay G
Strive for Perfection
 
Old July 21st, 2004, 05:57 AM
Authorized User
 
Join Date: Jun 2003
Posts: 13
Thanks: 0
Thanked 0 Times in 0 Posts
Default

That worked for me too if I setup on two other servers. Only it is giving problem with these two servers (may be setup related issue).

The only difference I can see here one is windows 2000 server and the other one windows 2003 server. Does this make any difference?





Similar Threads
Thread Thread Starter Forum Replies Last Post
Distributed Transaction Error ejan Pro VB 6 7 July 24th, 2006 08:01 AM
Distributed Transaction Coordinator fkumar BOOK: ASP.NET 2.0 Website Programming Problem Design Solution ISBN: 978-0-7645-8464-0 2 July 21st, 2006 12:26 AM
Linked Servers msrnivas .NET Web Services 1 January 8th, 2005 09:27 AM
Distributed Transaction in different web services avanishp .NET Web Services 1 December 16th, 2004 12:39 AM
linked servers msrnivas General .NET 1 November 26th, 2004 01:19 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.