InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comMon, 20 May 2013 11:06:22 GMT20http://www.sqlservercentral.com/Forums/Topic871816-338-1.aspxYou have to use :[i][b]SET XACT_ABORT ON/OFF[/b][/i]opition to Distributed Queries from one server to another server.Have a look on Distributed Queries and Distributed Transactions so that you will be getting some idea on server to server processing of data.Tue, 05 Apr 2011 15:38:29 GMTparthi-1705http://www.sqlservercentral.com/Forums/Topic871816-338-1.aspx[quote][b]borra2005 (2/24/2010)[/b][hr]Hi,I have an SP, with in that SP there is a transaction, when i try to call another SP which is in other data base ans has a delete statement, i couldn't able to delete the record. But if i remove the transaction and call the delete SP, i could make it.What is the way to use cross data base transactions? Thanks in advance,Borra.[/quote]What is the error that you are encountering?Mon, 04 Apr 2011 00:36:54 GMTNakul Vachhrajanihttp://www.sqlservercentral.com/Forums/Topic871816-338-1.aspxCan you show the code that doesn't work and add the error that you are getting?AdiWed, 24 Feb 2010 04:34:17 GMTAdi Cohn-120898http://www.sqlservercentral.com/Forums/Topic871816-338-1.aspxHi,I have an SP, with in that SP there is a transaction, when i try to call another SP which is in other data base ans has a delete statement, i couldn't able to delete the record. But if i remove the transaction and call the delete SP, i could make it.What is the way to use cross data base transactions? Thanks in advance,Borra.Wed, 24 Feb 2010 04:05:29 GMTborra2005