Microsoft SQL Server 4.2.x or 6.0

Problem: SQL passthrough w/one start transaction and 
3 updates that fail (key violation on at least two 
tables) will prevent a rollback and leave page locks 
on the server.  Resulting error indicates a new 
transaction cannot be started because of pending results.


Fix: Microsoft Bug fix NT255 SQLServer Pack 5.

Workaround:  Execute rollback twice, MS suggests a FOR loop.

The problem also occurs on Sybase 4.2.x.  It is not known 
if fix from Sybase exists.


ID:CS1019

CJ
1.16.96