The database is in single-user mode, and a user is currently connected to it

PROBLEM:
You get one of the following errors in Microsoft Sql Server Management Studio when trying to access database

• Database is already open and can only have one user at a time.
• Changes to the state or options of database cannot be made at this time. The database is in single-user mode, and a user is currently connected to it.

SOLUTION:
You need to kill all database sessions and get the database out of single-user mode

use master

GO

-- the following query lists all database sessions

select d.name, d.dbid, spid, login_time, nt_domain, nt_username, loginame

from sysprocesses p inner join sysdatabases d on p.dbid = d.dbid

where d.name = 'db_name'

GO

-- kill session using SPID number

kill 52

GO

exec sp_dboption 'db_name', 'single user', 'FALSE'

GO

If you find this solution useful, you are welcome to press one of the ads in this page.. Thanks!