BEGIN TRAN
–Delete from table.
DELETE FROM blah where blah

IF @@ERROR <> 0
BEGIN
ROLLBACK TRAN
return -1
END

–NOW delete from other table
DELETE FROM blah2 where blah2

IF @@ERROR <> 0
BEGIN
ROLLBACK TRAN
return -1
END

COMMIT TRAN