Welcome to MSDN Blogs Sign in | Join | Help

Browse by Tags

All Tags » SQL Exception Handling   (RSS)
Friday, April 07, 2006 8:46 PM

Server Side Error Handling - Part 3 (Why do I still see error messages from inside tsql try-block?)

There are cases when you see error messages relayed from inside the try-block. Some are intuitive and some are not. Compile Errors - These errors can simply not be caught. This is true for any programming language. When compilation of a program generates
Posted by NaveenP | 1 Comments
Monday, April 03, 2006 9:08 PM

Server Side Error Handling - Part 2 (Errors and Error Messages)

Each error in the server has two parts - an error message that describes the error that happened in the server and an error action that determines the effect of the error on the statement, level, batch, transaction, connection and/or server. Server has
Posted by NaveenP | 2 Comments
Thursday, March 30, 2006 7:17 PM

Server Side Error Handling - Part 1 (Migrating from @@error to tsql try-catch)

Tsql try-catch was added to improve server side error handling in sql server 2005. This feature should have been part of early T-Sql. Better late than never. In absence of tsql try-catch, server-side error handling was done using @@error. This had necessitated
Posted by NaveenP | 0 Comments
 
Page view tracker