Try
BEGIN TRY
BEGIN TRANSACTION
UPDATE [Company]
SET [CompanyName] = @CompanyName,
[CompanyRegistry] = @CompanyRegistry
FROM [Company] T1
WHERE [T1.CompanyID] = @CompanyID
UPDATE [Users]
SET [FirstName] = @FirstName,
[LastName] = @LastName,
[Address] = @Address,
[City] = @City,
[State] = @State,
[ZipCode] = @ZipCode,
[PhoneNumber] = @PhoneNumber,
[EMail] = @EMail
FROM [Users] T2
WHERE [T2.UsersID] = @UsersID
COMMIT TRANSACTION
END TRY
BEGIN CATCH
ROLLBACK TRANSACTION
END CATCH
You may find the below article helpful
SQL Server Transactions and Error Handling[
^]