Path: csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!news.albasani.net!eternal-september.org!feeder.eternal-september.org!.POSTED!not-for-mail From: Erland Sommarskog Newsgroups: comp.databases.ms-sqlserver,microsoft.public.sqlserver.programming Subject: Re: SSE 2008: Transactions and Rollbacks: When are they done? Followup-To: comp.databases.ms-sqlserver Date: Fri, 20 May 2011 07:32:09 +0000 (UTC) Organization: Erland Sommarskog Lines: 18 Message-ID: References: <91q5t6h56vk3db1ipt8eacd5407jc08c7f@4ax.com> <9618t6ta7j80ptb76ko10h873g28v5dsmf@4ax.com> <91uat6d92cg68lk6472coa3okuque54tde@4ax.com> <0g1ct6hmqe2hs0djmofsgi7bami29mc16b@4ax.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit Injection-Date: Fri, 20 May 2011 07:32:09 +0000 (UTC) Injection-Info: mx04.eternal-september.org; posting-host="G7+Jz22XqYCG8C6rb1H3YA"; logging-data="16054"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1/sB06p3/biD6RJUko+vqgZ" User-Agent: Xnews/2005.10.03 Mime-proxy/1.4.c.4 (Win32) Cancel-Lock: sha1:X3L7tW+4D9ltz8lIeTX1/9dPnPo= Xref: x330-a1.tempe.blueboxinc.net comp.databases.ms-sqlserver:361 Gene Wirchenko (genew@ocis.net) writes: > Nope. If the severity is <=10, then raiserror() will not result > in the catch block triggering. This is documented. I do not know why > it is this way, but it is. Sorry, the severity is implied. The meaing of the severity levels are documented in Books Online somewhere, but I think you find a quicker summary on http://www.sommarskog.se/error-handling-I.html#severitylevels. -- Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se Books Online for SQL Server 2005 at http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx Books Online for SQL Server 2000 at http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx