Home Forums SQL Server 2005 T-SQL (SS2K5) Delete other database record within the trasaction is not possible RE: Delete other database record within the trasaction is not possible

  • April 5, 2011 at 3:38 pm

    #1307749

    You have to use :

    SET XACT_ABORT ON/OFF

    opition to Distributed Queries from one server to another server.

    Have a look on Distributed Queries and Distributed Transactions so that you will be getting some idea on server to server processing of data.

    Thanks
    Parthi