Recent content by TechSpiders

Thanks for the replys, Msdtc is fully enabled on both servers. Netic there is a windows firewall, and I have added an exception for MSDTC and opened port 135. Following is the steps i took... To fully enable MSDTC: 1 - In Control Panel, open Administrative Tools, and then double-click...

Firewall are allowed for MS DTC

Ya same setting on MS DTC on both the server

Yes MS DTC is running Here what is selected: Network DTC Access (Checked) Allow Remote Client (Checked) Allow Remote Administration(Checked) Allow Inbound and Allow outbound (Both Checked) Manual Authentication Required(Checked) Enable Transaction Internet Protocol(TIP) Transactions(Checked)...

when i execute without using transaction it works but why not using transaction INSERT INTO [SERVERNAME1].[DATABASENAME].[dbo].[TABLENAME](PurchaseByUserID,price,purchasedate,affiliateID,LicenseeID,debittype) SELECT PurchaseByUserID,price,purchasedate,affiliateID,LicenseeID,debittype FROM...

Yes MS DTC is running in both server How to SET REMOTE_PROC_TRANS 1 ?

Hi, purchasedate is type of Datetime I tried SET XACT_ABORT ON on Top but same error is comming here is the Sql block: SET XACT_ABORT ON BEGIN TRAN BEGIN TRY INSERT INTO [SERVERNAME1].[DATABASENAME].[dbo].[TABLENAME](PurchaseByUserID,price,purchasedate,affiliateID,LicenseeID,debittype)...

Hi all, I m trying to get records from one server to another using Commit and Rollback feature in the Sql Server and getting this error message-- "No transaction is active." below is my sql block BEGIN TRAN BEGIN TRY INSERT INTO...