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

Some Doubt

X-Received	by 10.224.42.141 with SMTP id s13mr1098560qae.3.1369811530505; Wed, 29 May 2013 00:12:10 -0700 (PDT)
X-Received	by 10.50.25.33 with SMTP id z1mr1974609igf.16.1369811530428; Wed, 29 May 2013 00:12:10 -0700 (PDT)
Path	csiph.com!newsfeed.hal-mli.net!feeder3.hal-mli.net!newsfeed.hal-mli.net!feeder2.hal-mli.net!border3.nntp.dca.giganews.com!border1.nntp.dca.giganews.com!nntp.giganews.com!p1no1312030qaj.0!news-out.google.com!y6ni57070qax.0!nntp.google.com!ch1no2701637qab.0!postnews.google.com!glegroupsg2000goo.googlegroups.com!not-for-mail
Newsgroups	comp.databases.ms-sqlserver
Date	Wed, 29 May 2013 00:12:10 -0700 (PDT)
Complaints-To	groups-abuse@google.com
Injection-Info	glegroupsg2000goo.googlegroups.com; posting-host=27.251.38.10; posting-account=Qo0bVAoAAAAeSY6bdK6bdmMu_5U_5927
NNTP-Posting-Host	27.251.38.10
User-Agent	G2/1.0
MIME-Version	1.0
Message-ID	<0a7b5498-c6dd-422e-a047-2af7466127b1@googlegroups.com> (permalink)
Subject	Some Doubt
From	SUBBU N <nsubbu1986@gmail.com>
Injection-Date	Wed, 29 May 2013 07:12:10 +0000
Content-Type	text/plain; charset=ISO-8859-1
Lines	13
Xref	csiph.com comp.databases.ms-sqlserver:1495

Show key headers only | 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