I'm Using Transaction Scope to implement a transaction against SQL Server 2000.
Locally its working Perfectly and no problem happens; but when trying to do the same action on a remote server it dosn't work; it gives no errors or exception just doesn't rollback when an exception appears before Completion.
The server's DTC Service is working, and no firewall is installed at the SQl Server machine
Does anyone know what may be the reason for that, and how to resolve this issue?
Locally its working Perfectly and no problem happens; but when trying to do the same action on a remote server it dosn't work; it gives no errors or exception just doesn't rollback when an exception appears before Completion.
The server's DTC Service is working, and no firewall is installed at the SQl Server machine
Does anyone know what may be the reason for that, and how to resolve this issue?
Comment