Error Handling

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

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

A simple Machine Learning process example (supervised) – just to start with

By

I have just written the fifth article of the Machine Learning topic. !!! This...

Always On: Troubleshooting Consolidated

By

Working on Always On and configuration/setup of AG we have observed many errors. especially...

Changing Git Credentials in Windows

By

tl;dr For Windows when you need a different account. I had to work with...

Read the latest Blogs

Forums

Storing JSON data

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Storing JSON data

Memories of DR testing

By MVDBA

Comments posted to this topic are about the item Memories of DR testing

Phishing Defenses

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Phishing Defenses

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers