Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 


 
     
Recent Posts
   
Popular Topics
Home   
Search
    Members    Calendar    Who's On

Home » SQL Server 2005 » T-SQL (SS2K5) » Delete other database record within the...
Add to briefcase

Delete other database record within the trasaction is not possible Expand / Collapse
Rate Topic
Display Mode
Topic Options
Author
Message
borra2005
Posted Wednesday, February 24, 2010 4:05 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, January 20, 2011 7:49 AM
Points: 8, Visits: 26
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.
Post #871816
Adi Cohn-120898
Posted Wednesday, February 24, 2010 4:34 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Wednesday, May 22, 2013 9:50 AM
Points: 2,019, Visits: 4,923
Can you show the code that doesn't work and add the error that you are getting?

Adi

--------------------------------------------------------------
To know how to ask questions and increase the chances of getting asnwers:
http://www.sqlservercentral.com/articles/Best+Practices/61537/

For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Post #871825
Nakul Vachhrajani
Posted Monday, April 04, 2011 12:36 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: 2 days ago @ 1:02 AM
Points: 1,277, Visits: 1,609
borra2005 (2/24/2010)
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.


What is the error that you are encountering?

Thanks & Regards,
Nakul Vachhrajani.
http://beyondrelational.com/modules/2/blogs/77/nakuls-blog.aspx
Be courteous. Drive responsibly.

Follow me on
Twitter: @nakulv_sql
Google Plus: +Nakul
Post #1087915
parthi-1705
Posted Tuesday, April 05, 2011 3:38 PM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Wednesday, December 26, 2012 11:03 PM
Points: 586, Visits: 2,195
You have to use :

SET XACT_ABORT ON/OFF

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.

Thanks
Parthi
Post #1088955
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse

 
 
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved. Privacy Policy. Terms of Use. Report Abuse.