Error Handling

External Article

ERROR_PROCEDURE Does Not Return a Schema Name

  • Article

"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…"

2011-01-26

2,799 reads

External Article

Handling SQL Server Errors

  • Article

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.

2010-05-17

5,003 reads

Blogs

About blogging

By

A friend wants to get started and write a blog, and so asked me...

Daily Coping 26 Nov 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Daily Coping 25 Nov 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

ODBC - Pipeline component has returned HRESULT error code 0xC0208457

By yrstruly

I am trying to connect to MYSQL as a target/destination via ODBC. I am...

Trouble connecting MYSQL in SSIS

By yrstruly

I connect to MYSQL in SSIS with MYSQL data provider. I am getting the...

Which version of SQL should I use?

By curtisharrington

I see SQL as a query language, used to store and retrieve data. However,...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers