[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 199
  • 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

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

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