Drawing the world RSS FEED

USE master;
GO

DECLARE @LoginName nvarchar(218);
SET @LoginName = '[로그인명]';



DECLARE @Query nvarchar(4000);
DECLARE @SPID int;

DECLARE Kill_Cursor CURSOR FOR
	SELECT SPID
	FROM  master.dbo.sysprocesses
	WHERE SPID <> @@SPID
	  AND loginame = @LoginName;

OPEN Kill_Cursor;

FETCH Kill_Cursor INTO @SPID;
WHILE @@FETCH_STATUS = 0
BEGIN
	SET @Query = 'KILL ' + CONVERT(varchar, @SPID) + ';';
	PRINT @Query;
	EXECUTE sp_executesql @Query;
	FETCH Kill_Cursor INTO @SPID;
END;

CLOSE Kill_Cursor;
DEALLOCATE Kill_Cursor;
GO