Home > IT Answers > Database > alter database
Fhhdjfhjdhfjhjdfh
135 pts.
 alter database
Northwind sample database, Run Commands, SQL Server
HI,

when i run the command

alter database northwind set multi_user with rollback immediate

the northwind database shows ACCESS denied and tagged as SINGLE USER i donot understand why it so .can u pls explain .



Software/Hardware used:
sql server
ASKED: May 21, 2010  10:36 AM
UPDATED: April 11, 2011  12:36 PM
RELATED QUESTIONS
Answer Wiki:
right click on the database --. go to properties --> go to options --> at last u can see the state clause in this u can see the restrict options --> there u can set the multi_users
Last Wiki Answer Submitted:  April 11, 2011  12:36 pm  by  MuhammadAbid   75 pts.
All Answer Wiki Contributors:  MuhammadAbid   75 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

try
USE master
GO
alter database northwind
set multi_user with rollback immediate
GO

cquille
 10 pts.