Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by TechSpiders

  1. TechSpiders

    Problem transfering data between servers

    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...
  2. TechSpiders

    Problem transfering data between servers

    Firewall are allowed for MS DTC
  3. TechSpiders

    Problem transfering data between servers

    Ya same setting on MS DTC on both the server
  4. TechSpiders

    Problem transfering data between servers

    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)...
  5. TechSpiders

    Problem transfering data between servers

    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...
  6. TechSpiders

    Problem transfering data between servers

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

    Problem transfering data between servers

    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)...
  8. TechSpiders

    Problem transfering data between servers

    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...
See more

Part and Inventory Search

Back
Top