• The READ_COMMITTED_SNAPSHOT option can only be set if you are the only connection to the database.  So when you see that command running for a long time, it is waiting for all the other connections to close.

    You need to add a termination clause to the command to make sure it doesn't run forever, such as: WITH NOWAIT or WITH ROLLBACK AFTER 30 SECONDS

    e.g. ALTER DATABASE webctdatabase SET READ_COMMITTED_SNAPSHOT ON WITH NOWAIT