Prozesse von Microsoft SQL Server Killen

Kategorien:

• Programmierung,
• SQL

von ralf

DECLARE @spid	 int

DECLARE CUR CURSOR FOR
	SELECT spid FROM sysprocesses WHERE program_name = 'Name der Anwendung' AND loginame = 'Name des SQL Benutzers'

OPEN CUR

FETCH NEXT FROM CUR INTO @spid

WHILE @@FETCH_STATUS = 0
BEGIN
	EXECUTE ('KILL ' + @spid)
	FETCH NEXT FROM CUR INTO @spid
END

CLOSE CUR
DEALLOCATE CUR