Rollback?
-
Hi all, My application uses 2 different databases. so rollback condition here very complex. example. 1. insert into tableA ---DB1 (points db1) 2. insert into tableA ---DB2 (points db2) if second qury fails i want to rollback with respective databases. How can i do that?
-
Hi all, My application uses 2 different databases. so rollback condition here very complex. example. 1. insert into tableA ---DB1 (points db1) 2. insert into tableA ---DB2 (points db2) if second qury fails i want to rollback with respective databases. How can i do that?
Are you using .NET? If so you can append a transation object to the command for each database and roll back or commit using them. But I think MS has some sort of DTC which I know nothing about.
A man said to the universe: "Sir I exist!" "However," replied the Universe, "The fact has not created in me A sense of obligation." -- Stephen Crane
-
Hi all, My application uses 2 different databases. so rollback condition here very complex. example. 1. insert into tableA ---DB1 (points db1) 2. insert into tableA ---DB2 (points db2) if second qury fails i want to rollback with respective databases. How can i do that?
Look up BEGIN DISTRIBUTED TRANSACTION in SQL Server Books Online. [edit]See here: clickety[^][/edit] -- modified at 10:33 Friday 4th August, 2006
--EricDV Sig--------- Some problems are so complex that you have to be highly intelligent and well informed just to be undecided about them. - Laurence J. Peters