SET XACT_ABORT on

SET XACT_ABORT on
begin transaction test
select 1/0
go
select 1
commit transaction test
go

SET XACT_ABORT off
begin transaction test
select 1/0
select 1
commit transaction test

 

SET XACT_ABORT on
begin transaction test
select 1/0
go
select 1
commit transaction test
go