CREATE PROCEDURE [dbo].[KillOpenedDBSessions]

	@DBName nvarchar(255)
AS
BEGIN
	
	SET NOCOUNT ON;

DECLARE @DatabaseName nvarchar(50)
DECLARE @SPId int
DECLARE @SQL nvarchar(100)

SET @DatabaseName = @DBName

DECLARE my_cursor CURSOR FAST_FORWARD FOR
SELECT SPId FROM MASTER..SysProcesses
WHERE DBId = DB_ID(@DatabaseName) AND SPId <> @@SPId

OPEN my_cursor

FETCH NEXT FROM my_cursor INTO @SPId

WHILE @@FETCH_STATUS = 0
BEGIN
 SET @SQL = 'KILL ' + CAST(@SPId as nvarchar(10))
 print @SQL
 EXEC sp_executeSQL @SQL
 --KILL @SPId -- Causing Incorrect syntax near '@spid'.

 FETCH NEXT FROM my_cursor INTO @SPId
END

CLOSE my_cursor
DEALLOCATE my_cursor
SELECT SPID,status,hostname,program_name,loginame,login_time FROM MASTER..SysProcesses
WHERE DBId = DB_ID(@DatabaseName) 
--AND SPId <> @@SPId
SELECT @@Spid as my sesion


END