DCSIMG
DEV,SQL Server 2005 - Gilad Lavian's Blog

Gilad Lavian's Blog

In Development

Browse by Tags

All Tags » DEV » SQL Server 2005 (RSS)
Sorry, but there are no more tags available to filter with.
MS-SQL: Changing single user Database to multi users
The problem: Changes to the state or options of database "DatabaseName" cannot be made at this time. The database is in single-user mode, and a user is currently connected to it. The solutions: use master go alter database "DatabaseName" set multi_user; If there's users connected to the Database and you don't know who, you can use "sp_who2" to check who's connected. You can kill only user process by there SPID: kill 15;