Post reply

sqlserver 2008 transaction management

  • November 13, 2008 at 9:01 am

    #215174

    Hi all.

    I am a sqlserver 2008 newbie and I would want to know if sqlserver 2008 is able to manage transaction with more than one database istance.

    I would want to know just if I manage entities that stand in more than an istance of database can I manage the commit or rollback of these entities in only one transaction statement?

    Thanks

    rf

  • November 13, 2008 at 2:04 pm

    #898308

    Hi,

    Yes you can. You can set up a Linked Server to the other instance (described in Books Online) and then use BEGIN DISTRIBUTED TRANSACTION. Under the hood the MSDTC will be used to handle these transactions.

    HTH!

    /Elisabeth

    elisabeth@sqlserverland.com
    MCITP | MCT
    http://sqlblog.com/blogs/elisabeth_redei/
    http://linkedin.com/in/elisabethredei

  • November 14, 2008 at 1:31 am

    #898441

    thank you very much betty

    r

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

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