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

Honored to be a Microsoft MVP Again

By

I was renewed this week as a Microsoft MVP. This is my 15th award...

Daily Coping 6 Jul 2022

By

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

Snowflake Data Cloud

By

Time to shift gears away from the world of relational databases whether that is...

Read the latest Blogs

Forums

Establishing a Connection to PostgreSQL with GoLang

By sabyda

Comments posted to this topic are about the item Establishing a Connection to PostgreSQL...

Logshipping meta data is not updated

By ramyours2003

Meta data in Log shipping tables are not updated  in msdb  when i checked...

Updating a table with YES and NO in a field

By chaunnahrailey@gmail.com

I have an  issue just brought to my attention.  If the apdelay = 0...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers