When I try to execute any SQL statement in Windows server 2003 with BEGIN TRAN and COMMIT TRAN, the query is getting HANG.
If I comment the BEGIN TRAN and COMMIT TRAN, then everything is working fine.
Is there any problem with the MSDTC settings or what could be the issue?
Thanks & waiting for your response.
This is SQL Server 2008?
Then I'd suggest you gather data using the dynamic management objects. Start with sys.dm_exec_requests. It'll show you the status of running commands and, most importantly, the exact things that a process is waiting on. With that you can figure out what's going wrong.
Also, while it's possible to connect "up" as it were, running queries against 2008 from the 2000 interface, you're going to run into problems doing this. I recommend strongly against it. Use the correct version and connect "down" but not "up"
answered Nov 24 '09 at 10:13 AM
Grant Fritchey ♦♦
Can you clarify how long you've waited for the transaction to complete? Also, can you detail:
answered Nov 20 '09 at 06:13 AM
Matt Whitfield ♦♦