Alter Database users

Set Database to single/multiple user


ALTER DATABASE Test

      SET SINGLE_USER WITH ROLLBACK IMMEDIATE 

GO 

ALTER DATABASE Test 

      MODIFY NAME = TestDemo

GO 

ALTER DATABASE TestDemo

      SET MULTI_USER 

GO 

No comments:

Post a Comment