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

  • 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