Transaction In Sql Server

Posted by Alok under Interview Questions on 12/18/2011 | Points: 10 | Views : 2954 | Status : [Member] | Replies : 3

How Can We Perform Transaction Between Two Table of Two Different Databases...

Thanks & Regards,
Alokssm

Reply | Reply with Attachment

Posted by: Vuyiswamb on: 12/18/2011 [Member] [MVP] [Administrator] NotApplicable | Points: 25

0	Yes you can do that SELECT * FROM DATABASE1.DBO.TABLE1 DB1 INNER JOIN DATABASE2.DBO.TABLE2 DB2 ON DB1.MATCHFIELD = DB2.MATCHFIELD Thank you for posting at Dotnetfunda [Administrator] Alok, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Sksamantaray on: 12/19/2011 [Member] Silver | Points: 25

0	Go ahead with Answer of Mr.Vuyiswamb provided the databases are in same machine Thanks, Sanjay Alok, if this helps please login to Mark As Answer. \| Alert Moderator

Posted by: Arefin on: 12/19/2011 [Member] Starter | Points: 25

0	You can see the link: http://forums.asp.net/t/1096615.aspx/1 Thanks, Arefin Alok, if this helps please login to Mark As Answer. \| Alert Moderator

Latest Posts