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

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

From	Erland Sommarskog <esquel@sommarskog.se>
Newsgroups	comp.databases.ms-sqlserver, microsoft.public.sqlserver.programming
Subject	Re: SSE 2008: Transactions and Rollbacks: When are they done?
Date	2011-05-19 23:38 +0200
Organization	Erland Sommarskog
Message-ID	<Xns9EEAF07EABDAFYazorman@127.0.0.1> (permalink)
References	<91q5t6h56vk3db1ipt8eacd5407jc08c7f@4ax.com> <Xns9EE9602FD7B17Yazorman@127.0.0.1> <9618t6ta7j80ptb76ko10h873g28v5dsmf@4ax.com> <Xns9EE9F09B4267EYazorman@127.0.0.1> <91uat6d92cg68lk6472coa3okuque54tde@4ax.com>

Cross-posted to 2 groups.

Show all headers | View raw

Gene Wirchenko (genew@ocis.net) writes:
>      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).

RAISERROR should invokes the CATCH block, so much is right. This is
applies to both triggers and regular code.

As for what is documented or not is this madhouse I don't know. I only
know that the updated version of my article on error handling is long
overdue...

-- 
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx

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