Post reply

Delete other database record within the trasaction is not possible

  • February 24, 2010 at 4:05 am

    #143127

    Hi,

    I have an SP, with in that SP there is a transaction, when i try to call another SP which is in other data base ans has a delete statement, i couldn't able to delete the record. But if i remove the transaction and call the delete SP, i could make it.

    What is the way to use cross data base transactions?

    Thanks in advance,

    Borra.

  • February 24, 2010 at 4:34 am

    #1124192

    Can you show the code that doesn't work and add the error that you are getting?

    Adi

    --------------------------------------------------------------
    To know how to ask questions and increase the chances of getting asnwers:
    http://www.sqlservercentral.com/articles/Best+Practices/61537/

    For better answers on performance questions, click on the following...
    http://www.sqlservercentral.com/articles/SQLServerCentral/66909/

  • April 4, 2011 at 12:36 am

    #1306860

    borra2005 (2/24/2010)

    Hi,

    I have an SP, with in that SP there is a transaction, when i try to call another SP which is in other data base ans has a delete statement, i couldn't able to delete the record. But if i remove the transaction and call the delete SP, i could make it.

    What is the way to use cross data base transactions?

    Thanks in advance,

    Borra.

    What is the error that you are encountering?

    Thanks & Regards,
    Nakul Vachhrajani.
    http://nakulvachhrajani.com

    Follow me on
    Twitter: @sqltwins

  • 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

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply