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

Recover database encrypted modules code with dbatools

By

This article was initially posted on SQLServerCentral @ 2020-08-18. It was interesting some comments...

Azure SQL Offers Manual Failover for PaaS Resources

By

Sometime having the right command in place opens up new doors to test things,...

Azure SQL Offers Manual Failover for PaaS Resources

By

Sometime having the right command in place opens up new doors to test things,...

Read the latest Blogs

Forums

SSRS Query Designer not showing newly added measures

By sherrilmcdonald

We have recently added new measures to our existing cube in dev and test....

Cannot restore DB using T-SQL script

By jbeclapez

Hello, I had a database called Training_01 and did a backup of it. It...

Transaction log used space

By everand

It's a little weird for me. I have a database (AdventureWorks2014; SQL Server 2014)...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers