Breaking News: Grepper is joining You.com. Read the official announcement!

remove single user db

Clumsy Corncrake answered on September 27, 2022 Popularity 3/10 Helpfulness 1/10

answer remove single user db

related remove single user db

remove single user db

Comment

-- Just in case if someone stumbles onto this thread then here is a bullet proof solution to SQL Server stuck in SINGLE USER MODE

-- Get the process ID (spid) of the connection you need to kill
-- Replace 'DBName' with the actual name of the DB

SELECT sd.[name], sp.spid, sp.login_time, sp.loginame 
FROM sysprocesses sp 
INNER JOIN sysdatabases sd on sp.dbid = sd.dbid  
WHERE sd.[name] = 'DBName'
-- As an alternative, you can also use the command “sp_who” to get the “spid” of the open connection:

-- Or use this SP instead

exec sp_who
-- Then Execute the following and replace the [spid] and [DBName] with correct values

KILL SpidToKillGoesHere
GO

SET DEADLOCK_PRIORITY HIGH
GO

ALTER DATABASE [DBName] SET MULTI_USER WITH ROLLBACK IMMEDIATE
GO

Popularity 3/10 Helpfulness 1/10 Language sql

Source: stackoverflow.com

Tags: single-user sql

Link to this answer
Share Copy Link

Contributed on Sep 27 2022

Clumsy Corncrake

0 Answers Avg Quality 2/10

Closely Related Answers

remove single user db

Comment

-- Start in master
USE MASTER;

-- Add users
ALTER DATABASE [my_db] SET MULTI_USER
GO

Popularity 3/10 Helpfulness 4/10 Language whatever

Source: stackoverflow.com

Tags: single-user whatever

Link to this answer
Share Copy Link

Contributed on Oct 18 2022

Clumsy Corncrake

0 Answers Avg Quality 2/10

remove single user db

Contents

More Related Answers

remove single user db

Closely Related Answers

remove single user db

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.