Check whether the indexes on the tables are the same - hash match and clustered index scan both indicate that no useful index has been found.

The app is essentially a VB COM executable which runs a number of COM dlls. Each called dll is self-contained in terms of data access and may call others depending...

Thanks Steve

I have no problem identifying the open trans once it occurs but it is in an overnight update process so it is not as simple as killing the spid....