what does the second @@error return?

Easy Error Trapping When Using xp_cmdshell

Getting errors and output messages when using xp_cmdshell can be tricky. This method can solve your problems.

Best Practices for Exception Handling and Defensive Programming in Microsoft SQL Server

This is a deep dive developer session that explores error handling in SQL Server. The session focuses on core error handling areas such as understandign the anatomy of errors, detecting errors in TSQL and best practices for error handling and defensive programming in Microsoft SQL Server. tuesday, 1/26, 8:00am EST

Severity Levels

@@Error and sp_rename

On Error () Logging by Using Event Handlers

Use of event handlers provided in SSIS package to handle runtime errors while the package is running and logging the error information in the database.

TRY/CATCH - The Great Way to Handle Exceptions in SQL 2005/8

The goal of this post is to explain how to handle errors thanks to a useful T-SQL functionality, available since SQL 2005 onwards, that developers are already used to – and similar to how exceptions are handled in the Visual Studio environment.

Error Severity

Handling Service Broker Errors

The previous installment of the 'SQL Server 2005 Express Edition' series discussed using transactions to protect the integrity and consistency of Service Broker-based communication. Depending on the type of issue encountered by our code, the outcome might be different from expected. This article demonstrates a more robust approach to error handling and applies it to our target.

SSIS Custom Error Handling

This article from Zach Mattson shows how you can set up custom error handling in your SSIS packages. Learn how to direct those error rows to another component for separate processing.