SET XACT_ABORT ON
BEGIN TRY
BEGIN TRANSACTION
INSERT INTO pubs..jobs 
VALUES('fix fonts', 3, 20)
COMMIT TRANSACTION
END TRY
BEGIN CATCH
INSERT INTO pubs..jobs 
VALUES('add headlines', 10, 20)
PRINT 'We got to here'
END CATCH
select @@trancount

RAISERROR (N'asdf', 16, 1) WITH TRAN_ABORT

sp_helptext 'RAISERROR'
