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

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

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	2011-05-19 13:10 -0700
Organization	A noiseless patient Spider
Message-ID	<91uat6d92cg68lk6472coa3okuque54tde@4ax.com> (permalink)
References	<91q5t6h56vk3db1ipt8eacd5407jc08c7f@4ax.com> <Xns9EE9602FD7B17Yazorman@127.0.0.1> <9618t6ta7j80ptb76ko10h873g28v5dsmf@4ax.com> <Xns9EE9F09B4267EYazorman@127.0.0.1>

Cross-posted to 2 groups.

Show all headers | 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