Транзакция: частично выполнилась

ALTER PROCEDURE [dbo].[InsertWork] 
    @surname VARCHAR,
    @name VARCHAR,
    @workname VARCHAR
AS
BEGIN
DECLARE @err int
 
SET NOCOUNT ON
SET ANSI_WARNINGS OFF
 
DECLARE @wp int; --IDWorkPerson
 
BEGIN TRANSACTION
 
DECLARE @newid INT, @newwork INT, @newpwid int;
set @newid = (select ISNULL(MAX(ID),0) from Person) + 1;
INSERT INTO person(id, surname, name) values(@newid, @surname, @name); 
 
 
INSERT INTO WORK(name) VALUES(@workname);
SET @newwork = @@identity;
 
-- Здесь ошибка
SET @newpwid = (select MAX(ISNULL(ID,0)) from PersonWork) + 1);
INSERT INTO PersonWork(ID, IDperson, IDwork) VALUES(@newpwid, @newid, @newwork);
-- далее некоторое количество Insert-ов
 
SET @err = @@ERROR
    if(@err <> 0)
        BEGIN
            ROLLBACK TRANSACTION
            INSERT INTO Errors(ErrorCode, ErrorTime, StoredName) VALUES(@err, GETDATE(), 'InsertWork');
            RETURN -1
        END
COMMIT TRANSACTION
 
RETURN @newpwid;
END
SET NOCOUNT OFF
SET ANSI_WARNINGS ON

BEGIN TRY
   BEGIN TRANSACTION;
   -- код внутри транзакции 
   COMMIT TRANSACTION;
END TRY
BEGIN CATCH
   -- обработка ошибок
   ROLLBACK TRANSACTION;
END CATCH