Link to home
Start Free TrialLog in
Avatar of htabbach
htabbachFlag for United States of America

asked on

Database stuch in single user mode

I have a database that is stuck in single user mode, when I try to alter to multi user from the master database it tells me it cannot alter it because it is used by another user. How do I fix this issue?

Thanks
Avatar of jogos
jogos
Flag of Belgium image

Determine who is using database  exec sp_who  or just open management studio  and go to the activity monitor.

Probably it's just you that has the the database selected in management studio. Just select another database and see there is no window opened with connections to that database.
ASKER CERTIFIED SOLUTION
Avatar of TempDBA
TempDBA
Flag of India image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial