Table of Contents
Problem/Description:
Cannot get the Database to go back into mulit user mode.
Answer:
For Checking the proccess IDs so you can kill them later
exec sp_who
SELECT request_session_id FROM sys.dm_tran_locks
WHERE resource_database_id = DB_ID(‘ReportServer’)
Command to kill the process id :
kill <Process ID>
Script to run for setting multi-user mode:
USE master;
ALTER DATABASE reportserver
SET MULTI_USER
–WITH ROLLBACK IMMEDIATE
GO
UNTESTED LINES BELOW:
USE master;
DECLARE @kill varchar(8000); SET @kill = ”;
SELECT @kill = @kill + ‘kill ‘ + CONVERT(varchar(5), spid) + ‘;’
FROM master..sysprocesses
WHERE dbid = db_id(‘ReportServer’)
EXEC(@kill);
kill 64
USE master
GO
ALTER DATABASE Reportserver
SET OFFLINE WITH ROLLBACK IMMEDIATE
GO
Resources:
https://stackoverflow.com/questions/24608702/sql-server-2008-r2-stuck-in-single-user-mode
