SET XACT_ABORT ON  

BEGIN TRANSACTION

INSERT INTO Tabela1 ....

IF @ERROR <> 0

GOTO Failure

INSERT INTO Tabela2 ...

IF @ERROR <> 0

GOTO Failure

COMMIT

RETURN

Failure:

ROLLBACK TRAN

 

In plus trebuie error handling in trigger.

---

Cristian Andrei Lefter, SQL Server MVP
MCT, MCSA, MCDBA, MCAD, MCSD .NET,
MCTS, MCITP - Database Administrator SQL Server 2005
http://sqlserver.ro