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 instances of different combinations of errors and error messages. The major ones…

2

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 statement abort as the error policy. Under this policy the execution of a…

0