Thursday, February 3, 2011

Set DB to Single/Multi User Mode

-- setting database to single user mode
ALTER DATABASE db_name SET SINGLE_USER WITH ROLLBACK IMMEDIATE

-- setting database to multi user mode
ALTER DATABASE db_name SET MULTI_USER
Posted by at
Labels:

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)