Cool video. At 3:05, if Xact_abort equals =-1, then it seems redundant to have a rollback transaction statement. I am somewhat new to how the engine works. If the rollback statement was not there, would SQLServer rollback the transaction anyway? When are rollbacks implicit?