While investigating a problem I believed to be related to lock escalation and thinking that READ_COMMITTED_SNAPSHOT would be the solution, I checked whether it was already enabled. To my surprise, the database had compatibility level 80 (SQL Server 2000, and I m new here, and nobody or document seems to know why!).
But READ_COMMITTED_SNAPSHOT was new in 2005. So even though it s enabled, does it have any affect when running in 2000 compatibility mode?