Bad Error Handling

ErrorHandling for running or deploying code

Do you ever wish you had a better way to run or deploy scripts? We use this format for all types of work.

Error messages

SQL Server Reporting Services Embedding .NET Code for Report Formatting and Error Handling

I want to embed code into my SQL Server Reporting Servers (SSRS) to allow special formatting for report output. How do I implement and deploy this code and what functionality can use this embedded code?

Logging and Error Handling for SQL Stored Procedures

Learn how to develop and test a template for logging and error handling in a multi-step SQL stored procedure

Re-throw Errors with Logging

This article brings you a technique and framework to use in your stored procedures that can allow you to re-throw and log errors.

Handling Errors in SQL Server 2012

The error handling of SQL Server has always been somewhat mysterious. Now at last, the THROW statement has been included in SQL Server 2012 that, when combined with the TRY...CATCH block, makes error handling far easier. Robert Sheldon explains all.

ERROR_PROCEDURE Does Not Return a Schema Name

"A recent blog entry I read reminded me again that I wanted to rant about an issue in SQL Server for quite some time now. SQL Server 2005 introduced the separation between user and schema. Though schemata already existed before SQL Server 2005, they really became usable with this version, imho. At the same time TRY...CATCH was a new way for structured error handling introduced. And so it finally became possible…"

Handling SQL Server Errors

This article covers the basics of TRY CATCH error handling in T-SQL introduced in SQL Server 2005. It includes the usage of common functions to return information about the error and using the TRY CATCH block in stored procedures and transactions.

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.