How long should SET READ_COMMITTED_SNAPSHOT ON take?
You can check the status of the READ_COMMITTED_SNAPSHOT setting using the sys.databases view. Check the value of the is_read_committed_snapshot_on column. Already asked and answered. As for the duration, Books Online states that there can’t be any other connections to the database when this takes place, but it doesn’t require single-user mode. So you may be … Read more