Transaction involving several databases ?

• pfouille

  Grasshopper

  Points: 23

  More actions

  July 31, 2006 at 1:38 am

  #366951

  Hi,

  Does anybody know if a transaction involving several databases (same instance) is possible ? And if yes, how can we do that ?

  Thanks,

  Pierre.

• David.Poole

  SSC Guru

  Points: 76001

  More actions

  July 31, 2006 at 2:06 am

  #652293

  Yes it is possible.

  Simply use fully qualified names for your objects.

  Northwind.dob.orders (database.owner.object)

  If your databases are on different boxes then you can use BEGIN DISTRIBUTED TRANSACTION.

  ROLLBACK and COMMIT are the same as for non-distributed transactions

  LinkedIn Profile

• Minaz Amin

  SSChampion

  Points: 11052

  More actions

  August 2, 2006 at 2:14 am

  #652753

  Hi,

  Check the following links for more info:

  http://support.microsoft.com/kb/314520/en-us

  http://support.microsoft.com/kb/306397/en-us

  http://support.microsoft.com/kb/306212/en-us

  Regds,

  Minaz Amin

   

  "More Green More Oxygen !! Plant a tree today"