How to change a Database Read-Only State

Posted by PandianS under Sql Server category on 7/7/2010 | Views : 5571

Changing to ReadOnly State:

ALTER DATABASE DotnetFundaDB SET  READ_ONLY WITH ROLLBACK IMMEDIATE

Changing to Read and Write State:

ALTER DATABASE DotnetFundaDB SET  READ_WRITE WITH ROLLBACK IMMEDIATE

Bookmark It

Latest Code Snipptes