How to change a Database's Restrict Access State

PandianS
Posted by PandianS under Sql Server category on | Views : 2483
Change to Single User State:
ALTER DATABASE DotnetFundaDB SET  SINGLE_USER WITH ROLLBACK IMMEDIATE
Change to Restricted User State:
ALTER DATABASE DotnetFundaDB SET  RESTRICTED_USER WITH ROLLBACK IMMEDIATE
Change to Multi-User State:
ALTER DATABASE DotnetFundaDB SET  MULTI_USER WITH ROLLBACK IMMEDIATE

Comments or Responses

Login to post response