SQL Server 2012 brings a new capability for error handling - rethrowing the original error. Is the rethrowed error really the original one? Why you have to be careful with THROW?  What should I test if I implement tRY/CATCH error handling in SQL Server? Finally, should I handle Transact SQL errors at all?

In this session we will answer these questions and explain how SQL Server database engine handles errors. We'll discuss best practices and demonstrate common mistakes and misunderstandings in error handling.

(no tags)