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
a
b
c
d
Msg 3930, Level 16, State 1, Line 9
The current transaction cannot be committed and
 cannot support operations that write to the log
 file. Roll back the transaction.
