Re: Same transaction on 2 different DB
From: Louis Davidson (dr_dontspamme_sql_at_hotmail.com)
Date: 10/20/04
- Next message: Mike Labosh: "Re: Error message"
- Previous message: Costi Stan: "Re: ALTER TABLE: drop all objects and recreate them."
- In reply to: checcouno: "Same transaction on 2 different DB"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 20 Oct 2004 11:23:31 -0500
You are fine. Transactions work perfectly (as perfect as possible :) across
databases.
-- ---------------------------------------------------------------------------- Louis Davidson - drsql@hotmail.com SQL Server MVP Compass Technology Management - www.compass.net Pro SQL Server 2000 Database Design - http://www.apress.com/book/bookDisplay.html?bID=266 Note: Please reply to the newsgroups only unless you are interested in consulting services. All other replies may be ignored :) "checcouno" <checcouno@discussions.microsoft.com> wrote in message news:12FEFC48-0BA5-4BD4-88CA-B43BDF548FEB@microsoft.com... > I've two different sql-server Db on the same server, i need to pass data > between the 2 db. If i call a stored procedure on one of this DB tha begin a > tran, select insert and update some table from both the DB, this transaction > has effects on both DB or only in the DB in which the stored procedure is? > > Example: > stored procedure mySP is on myDB1 > > mySp1 code: > ... > begin tran > > insert into myTable1_DB1 > (select * from myDB2.dbo.myTable1_DB2 where myField = myValue) > > delete from myDB2.dbo.myTable1_DB2 where myField = myValue > > commit tran > .... > > Thanks
- Next message: Mike Labosh: "Re: Error message"
- Previous message: Costi Stan: "Re: ALTER TABLE: drop all objects and recreate them."
- In reply to: checcouno: "Same transaction on 2 different DB"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
