Database stuch in single user mode

Posted on 2011-10-10
Last Modified: 2012-05-12
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?

Question by:htabbach
    LVL 25

    Expert Comment

    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.
    LVL 25

    Accepted Solution

    kill all the already existed connection. Run the following:_


    Featured Post

    Highfive Gives IT Their Time Back

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Join & Write a Comment

    Suggested Solutions

    Audit has been really one of the more interesting, most useful, yet difficult to maintain topics in the history of SQL Server. In earlier versions of SQL people had very few options for auditing in SQL Server. It typically meant using SQL Trace …
    How to leverage one TLS certificate to encrypt Microsoft SQL traffic and Remote Desktop Services, versus creating multiple tickets for the same server.
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
    Here's a very brief overview of the methods PRTG Network Monitor ( offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now