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

I'm not entirely sure, but it isn't really a transaction. It's just a select statement.

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

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?