How to change a Database's Restrict Access State

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

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

Bookmark It

Latest Code Snipptes