• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 201
  • Last Modified:

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
0
htabbach
Asked:
htabbach
1 Solution
 
jogosCommented:
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.
0
 
TempDBACommented:
kill all the already existed connection. Run the following:_


ALTER DATABASE <databaseName> SET MULTI_USER WITH ROLLBACK IMMEDIATE
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now