Hi,

DO you have the different types of Isolation Levels in SQL 2 K like 2005 ? I was not aware. I will try to do some reading on that. This is on SQL 2K and to make matters worse it has this crap design. Since the design change is not an option, I have been trying to think of various options like killing a blocking transaction if its blocking for more than a period of time, query governor limits etc. Do you have any advice on how to get rid of a blocking lock with Rollback or Commit ? This should ensure DB consistency since the data is so mission critical. I did reindexing and Update Stats. many times but that was never fruitful because of the design flaw.

Thank you,