I saw a comment in a book that in this INSTEAD OF Trigger, the fact that there is no rollback is an advantage. How is that? CREATE TRIGGER InsOrdDet ON [Order Details] INSTEAD OF INSERT AS DECLARE @qty int SELECT @qty=quantity FROM Inserted IF @qty<=(SELECT UnitsInStock FROM Products P JOIN Inserted I ON P.ProductID=I.ProductID) INSERT INTO [Order Details] SELECT * FROM Inserted ELSE RAISERROR('Not enough products in stock', 16, 1)