Well, in short - not possible.The same restriction for updateable views:
Any modifications, including UPDATE, INSERT, and DELETE statements, must reference columns from only one base table.
Approach that I believe is optimal: use transactions, possibly wrap your business logic into stored procedures. Code skeleton might look like below:
begin tran
<TSQL statement for table 1>
if @@error != 0 goto error
<TSQL statement for table 2>
if @@error != 0 goto error
commit tran
goto ok
error:
<error_handler>
rollback tran
ok: