I'm currently installing service pack 1 to webCT 6 Campus Edition (Virtual Learning Environment) which requires READ_COMMITTED_SNAPSHOT to be turned on.
I have connected to the database at administrator level (owner of db) and executed the following query:
ALTER DATABASE webctdatabase SET READ_COMMITTED_SNAPSHOT ON
The query runs but never finishes. I have been checking for changes using:
select name,is_read_committed_snapshot_on from sys.database
but the result is still 0 (off).
Interestingly I ran the following query and it completed successfully, instantly.
ALTER DATABASE webctdatabase SET ALLOW_SNAPSHOT_ISOLATION ON
Where am I going wrong?