CREATE PROCEDURE BadInsert
AS
DECLARE @myError int
BEGIN TRAN
INSERT INTO pubs..jobs VALUES('headlines', 3, 20)
COMMIT TRAN
a
