Rollback behavior due to an error in multi-statement transactions varies between MS SQL Server and other DBMSs. Please contact Microsoft for more detailed information on errors and the impact they have on multi-statement transactions.