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

Re: SSE 2008: Transactions and Rollbacks: When are they done?

Path	csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!gegeweb.org!de-l.enfer-du-nord.net!feeder2.enfer-du-nord.net!eternal-september.org!feeder.eternal-september.org!.POSTED!not-for-mail
From	Gene Wirchenko <genew@ocis.net>
Newsgroups	comp.databases.ms-sqlserver, microsoft.public.sqlserver.programming
Subject	Re: SSE 2008: Transactions and Rollbacks: When are they done?
Date	Thu, 19 May 2011 13:10:17 -0700
Organization	A noiseless patient Spider
Lines	24
Message-ID	<91uat6d92cg68lk6472coa3okuque54tde@4ax.com> (permalink)
References	<91q5t6h56vk3db1ipt8eacd5407jc08c7f@4ax.com> <Xns9EE9602FD7B17Yazorman@127.0.0.1> <9618t6ta7j80ptb76ko10h873g28v5dsmf@4ax.com> <Xns9EE9F09B4267EYazorman@127.0.0.1>
Mime-Version	1.0
Content-Type	text/plain; charset=us-ascii
Content-Transfer-Encoding	7bit
Injection-Info	mx04.eternal-september.org; posting-host="7Qrvczazr82YckO5XW8Vtw"; logging-data="31341"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1+lv0EWExk5pc+o2A99Zmxrdo8ttHWDG+Q="
X-Newsreader	Forte Agent 4.2/32.1118
Cancel-Lock	sha1:TPMCLjbxBleP9bleKpy6SxUpdDo=
Xref	x330-a1.tempe.blueboxinc.net comp.databases.ms-sqlserver:357

Cross-posted to 2 groups.

Show key headers only | View raw

On Wed, 18 May 2011 23:39:09 +0200, Erland Sommarskog
<esquel@sommarskog.se> wrote:

>Gene Wirchenko (genew@ocis.net) writes:

[snip]

>This is getting confusing even for me! You see, normally RAISERROR does not 
>terminate the batch, even if XACT_ABORT is on. But yes, in a trigger.
>This is probably for compatibility reasons.

     It does not say why it normally does.  I think the reason is that
a raiserror() with a severity >=11 triggers the catch block, but it is
not documented (that I can see).

[snip]

     Thank you for some of the help.  I would write "all", but I feel
I will probably need more later.  I would rather have better
documentation instead of all of this educated guessing.

Sincerely,

Gene Wirchenko

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

Thread

SSE 2008: Transactions and Rollbacks: When are they done? Gene Wirchenko <genew@ocis.net> - 2011-05-17 15:09 -0700
  Re: SSE 2008: Transactions and Rollbacks: When are they done? Erland Sommarskog <esquel@sommarskog.se> - 2011-05-18 07:27 +0000
    Re: SSE 2008: Transactions and Rollbacks: When are they done? Gene Wirchenko <genew@ocis.net> - 2011-05-18 10:50 -0700
      Re: SSE 2008: Transactions and Rollbacks: When are they done? Erland Sommarskog <esquel@sommarskog.se> - 2011-05-18 23:39 +0200
        Re: SSE 2008: Transactions and Rollbacks: When are they done? Gene Wirchenko <genew@ocis.net> - 2011-05-19 13:10 -0700
          Re: SSE 2008: Transactions and Rollbacks: When are they done? Erland Sommarskog <esquel@sommarskog.se> - 2011-05-19 23:38 +0200
            Re: SSE 2008: Transactions and Rollbacks: When are they done? Gene Wirchenko <genew@ocis.net> - 2011-05-19 23:20 -0700
              Re: SSE 2008: Transactions and Rollbacks: When are they done? Erland Sommarskog <esquel@sommarskog.se> - 2011-05-20 07:32 +0000

csiph-web