I have one transaction (no nested transactions)  wich wrappes several
updates and inserts in one batch.
There are several stored procedures in the batch. when there is a "Server:
Msg 8114, Level 16, State 1, Procedure sp{*filter*}kDb2, Line 0
Error converting data type varchar to int " in one of procedures
transaction is commited anyway . Even though Query Analyzer shows error
description all valid Inserts after and before problem procedure are


even though the line before that generated a data type conversion error .

is not this right that TRANSACTION must
rollback everything  if there is an error in the batch?

Does anybody knows why is this happening ?