Using a local transaction I have defined explicit transaction boundary and trying to insert records into multiple tables in a clustered environment. When ever there is an error I am unable to rollback the inserted records.
Where as when I am inserting in a non clustered environment rollback works fine. May I know what could be the reason?? :roll: