I am Using this code to close all connection of a database. Sometimes it works and some times it raise error like "Databas eis exclussively used by some process". what should i do.
CREATE PROCEDURE RemoveConnection
AS
DECLARE @SQL varchar(400)
DECLARE @DB NVARCHAR
set @DB=db_name()
SET @SQL = ''
SELECT @SQL = @SQL + 'Kill ' + Convert(varchar, SPId) + ';' FROM MASTER..SysProcesses WHERE DBId = DB_ID(@DB) AND SPId <> @@SPId
EXEC(@SQL)
GO
Please reply soon.