Groups > comp.databases.ms-sqlserver > #1495

Some Doubt

Newsgroups	comp.databases.ms-sqlserver
Date	2013-05-29 00:12 -0700
Message-ID	<0a7b5498-c6dd-422e-a047-2af7466127b1@googlegroups.com> (permalink)
Subject	Some Doubt
From	SUBBU N <nsubbu1986@gmail.com>

Show all headers | View raw

Hi Experts,
here onwards i will some qs regarding only for sqldba.can anyone clarify and suggest to me plz

I have two databases, based on first db execution sucessful move to
second, upon second db execution scucessful.. commit the
transaction..if anything fail roll back transaction from both dbs

Example: DB1 and DB2
DB1 has Dept and DB2 has Employee...
now if dept and Employee data successfull then commit data in both DBs
else rollback from both DBs..

Please help me how to handle this?

Back to comp.databases.ms-sqlserver | Previous | Next — Next in thread | Find similar

Thread

Some Doubt SUBBU N <nsubbu1986@gmail.com> - 2013-05-29 00:12 -0700
  Re: Some Doubt Erland Sommarskog <esquel@sommarskog.se> - 2013-05-29 22:57 +0200
  Re: Some Doubt SUBBU N <nsubbu1986@gmail.com> - 2013-05-30 02:40 -0700

csiph-web