March 5, 2013 at 12:46 am
how to update 2 tables in 2 different Db within same transaction ?
what if 2 Db are in different server ?
March 5, 2013 at 1:22 am
To update two different tables within two different servers you need to use distributed transactions.
March 5, 2013 at 2:10 am
how to implement distributed transactions?
Thanks.
March 5, 2013 at 3:09 am
See http://msdn.microsoft.com/en-us/library/ms188386.aspx
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply