http://boorow.com/Pages/Use_ALTER_DATABASE_to_allow_snapshot_isolation?query=Use%20ALTER%20DATABASE%20to%20allow%20snapshot%20isolation
If snapshot_isolation_state_desc = IN_TRANSITION_TO_ON, ALTER DATABASE ALLOW_SNAPSHOT_ISOLATION OFF will pause six seconds and retry the operation.It is a database ...