BEGIN TRY
DECLARE @myError int
BEGIN TRAN
INSERT INTO pubs..jobs 
VALUES('fix fonts', 10, 20)
INSERT INTO pubs..jobs 
VALUES('add headlines', 3, 20)
COMMIT TRAN
END TRY
BEGIN CATCH
IF XACT_STATE() <> 0 ROLLBACK TRAN
PRINT 'Error ' + 
CAST(ERROR_NUMBER() AS VARCHAR(4)) + 
' with severity ' + 
CAST(ERROR_SEVERITY() AS VARCHAR(5))
END CATCH


SELECT @@TRANCOUNT
--ROLLBACK TRAN
