none
How to change READ COMMITTED SNAPSHOT isolation level RRS feed

  • Question

  • Dear all,

    We are using SQL and Azure Service stack.

    We have one database that we have created and the we discover that it requires to use the READ COMMITTED SNAPSHOT isolation level.

    Due to that we try to change this parameter (which is 0 by default) using the following query :

    ALTER DATABASE <database name>
    SET READ_COMMITTED_SNAPSHOT ON
    WITH ROLLBACK IMMEDIATE;

    But we get an error that this parameter is unknown.

    I have try the same with an Azure SQL service and it works fine.

    Is there any way to set READ_COMMITTED_SNAPSHOT to on ?

    Thanks for help

    regards

    Thursday, November 7, 2019 1:51 PM

All replies