sqlserver 2008 transaction management

• roberto.fermanelli

  SSC Veteran

  Points: 278

  More actions

  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

• Elisabeth Rédei

  Hall of Fame

  Points: 3873

  More actions

  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

• roberto.fermanelli

  SSC Veteran

  Points: 278

  More actions

  November 14, 2008 at 1:31 am

  #898441

  thank you very much betty

  r