This is easiest way to kill all sessions of database.
USE [Master]
GO
DECLARE @DBName VARCHAR(100)
DECLARE @SPId VARCHAR(7000)
SELECT @DBName = 'DBAdmin'
SELECT @SPId = COALESCE(@SPId,'')+'KILL '+CAST(SPID AS VARCHAR)+'; '
FROM Master..SysProcesses
WHERE DB_NAME(DBId) = @DBName
PRINT @SPId
EXEC(@SPId)
GO
Great info, was just looking for it, thanks buddy!
ReplyDeleteThanks prawin for comments.
ReplyDeleteYou have to just change the DBAdmin to your database name.