SQL Server Performance

Distributed Transactions

Discussion in 'General Developer Questions' started by seanlo@jdg.co.za, Mar 27, 2006.

  1. seanlo@jdg.co.za New Member

    Hi There

    I realize this is probably a basic question or at least i hope so but i cannot get distributed transactions working.

    BOL is just driving me in circles.
    I am running SS2000, MSDTC is up and running on the server.

    I have added a trigger to a table where on insert or update the trigger fires and inserts a row to a remote server.

    When i execute the update or insert i get the error:
    Cannot start a distributed transaction.

    I have tried stating BEGIN DISTRIBUTED TRANSACTION before the update but i get the same error, i have also read up on SET REMOTE_PROC_TRANSACTIONS, but this is not a remote sp.

    I have already checked this linkhttp://support.microsoft.com/?kbid=816701.

    Also i have found references to checking various services are running etc, seems there is alot to setup to get MSDTC to work but i cannot find the setup in BOL, not sure everything i have to do to egt MSDTC to work ?

    Anyone maybe have a good link to exactly how to setup and troubleshoot distributed transactions ?

    Any help wpuld be greatly appreciated Thanx
  2. satya Moderator

  3. Twan New Member

    Also, which OS are you running? W2K3 per chance?


Share This Page