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.
| Author |
Topic |
|
ajaystar
Starting Member
1 Post |
 Posted - 2011-08-25 : 02:39:18
|
| Hi,We are facing following issue while executing the SP on Link Server."Distributed transaction Error completed. Either enlist this session in a new transaction or the NULL transaction."SCENARIO : - We are using link server(Distributed transaction) As we have implemented the Link Server on SqlServer 2008 it is pointing to SqlServer 2000.SP_A is on SqlServer 2008 and SP_B on sqlServer 2000.E.g.SP_A(Sql2008) is calling to SP_B(Sql2000) within the transaction scope. if any validation or error has occurred in SP_B (SqlServer 2000) we are unable to get actual error or validation message because control terminates from SP_B. and we get "Distributed transaction Error completed. Either enlist this session in a new transaction or the NULL transaction." If we remove the BEGIN DISTRIBUTES TRANSACTION from SP_A it's working fine and we can get the actual error or validation message from SP_B but we cannot remove this because transaction scope is very important for us if you know any other way to maintain the transaction scope and get the inner exception message please let us know.Our problem is we are unable to get actual error or validation message from SP_B (SqlServer 2000) on SP_A because control terminates from SP_B.it doesn't come back on SP_A(if we use transaction scope).Thanks,Ajay |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-08-25 : 07:37:31
|
| DTC is running on both servers?Checked SQL Server logs and event logs on both? |
 |
|
|
|
|
|
Distributed transaction Error