How to change a Database Read-Only State

PandianS
Posted by PandianS under Sql Server category on | Views : 4488
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

Comments or Responses

Login to post response