Search This Blog

Friday, February 20, 2015

How to change database to single user mode as well as multi-user mode?

A. To change your database mode to single user mode execute below sql script
ALTER DATABASE Databasename SET SINGLE_USER WITH ROLLBACK IMMEDIATE;

b. To change your database mode to multi-user mode execute below sql script
ALTER DATABASE Databasename SET MULTI_USER WITH ROLLBACK IMMEDIATE;

No comments:

Post a Comment