Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.databases.ms-sqlserver > #329
| From | Erland Sommarskog <esquel@sommarskog.se> |
|---|---|
| Newsgroups | comp.databases.ms-sqlserver, microsoft.public.sqlserver.programming |
| Subject | Re: SS 2008: Rethrowing User-Defined Error Codes *FULLY* |
| Followup-To | comp.databases.ms-sqlserver |
| Date | 2011-05-13 07:43 +0000 |
| Organization | Erland Sommarskog |
| Message-ID | <Xns9EE462DBB9AD5Yazorman@127.0.0.1> (permalink) |
| References | <po4ps6d55puofc0uvrv43h34pesscjalb7@4ax.com> |
Cross-posted to 2 groups.
Followups directed to: comp.databases.ms-sqlserver
Gene Wirchenko (genew@ocis.net) writes: > Is there something that I am overlooking? Not really, I think you have summrised the alternatives quite well. What I can add is: 1) I don't like user-defined messages as they work today in SQL Server for two reasons: a) They are defined on server-level. b) Numbers are not very mnemonic. 2) Look at http://www.sommarskog.se/error_handling_2005.html which is a variation of your first alternative, but the re-raised message is formatted to make it easy to parse. 3) The next version of SQL Server will have command for re-raising errors exactly as they were given. -- 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
Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar
SS 2008: Rethrowing User-Defined Error Codes *FULLY* Gene Wirchenko <genew@ocis.net> - 2011-05-12 19:35 -0700
Re: SS 2008: Rethrowing User-Defined Error Codes *FULLY* Erland Sommarskog <esquel@sommarskog.se> - 2011-05-13 07:43 +0000
Re: SS 2008: Rethrowing User-Defined Error Codes *FULLY* Gene Wirchenko <genew@ocis.net> - 2011-05-13 11:22 -0700
Re: SS 2008: Rethrowing User-Defined Error Codes *FULLY* Erland Sommarskog <esquel@sommarskog.se> - 2011-05-13 23:27 +0200
csiph-web