We have recently been parachuted to a new ETL project with very bad code. I have in my hands a query with 700 rows and all sort of update. I would like to debug it with SET XACT_ABORT ON; and the g...

I have a try catch block in my SP with just a insert statement in the try. The catch checks the error code to see if it is PK violation, if it is then do an update. But sometimes I get and error: ...

I understand the purpose of SET XACT_ABORT command: When SET XACT_ABORT is ON, if a Transact-SQL statement raises a run-time error, the entire transaction is terminated and rolled back. ...

What is the scope of a SET XACT_ABORT statement in SQL Server 2005? i.e.:begin-end block, procedure or trigger, connection, database, server?

I'm trying to improve the error handling of a current system to produce more meaningful error messages. I have a "root" stored procedure that makes several calls to other nested stored procedures. ...

Based on the Books Online documentation of SET XACT_ABORT ON, i get the impression that if a T-SQL statement raises a run-time error, the entire transaction is terminated and rolled back: Remark...