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

Sometimes you might get the above error message from SQL Server when you try to change the user mode from MULTI to SINGLE. You have to explicitly kill the connection in order to solve the problem. First you need the dbid of your database. Run the following command. 1: SELECT name, database_id 2: FROM sys.databases … Continue reading The database is in single-user mode, and a user is currently connected to it.

Advertisements