boubkhaled · March 17, 2021 08:55
diff --git a/kill_sqlserver_database_processes.sql b/kill_sqlserver_database_processes.sql
 DECLARE @id bigint
 DECLARE @temp TABLE(id  bigint)
 INSERT @temp SELECT spid FROM master.dbo.sysprocesses WHERE dbid = db_id('Database_Name') 

 WHILE EXISTS(SELECT TOP 1 1 FROM @temp)
 BEGIN
  SET @id = (SELECT TOP 1 id FROM @temp)
  EXEC('kill ' + @id)
  DELETE @temp WHERE id = @id
 END
	DECLARE @id bigint
	DECLARE @temp TABLE(id bigint)
	INSERT @temp SELECT spid FROM master.dbo.sysprocesses WHERE dbid = db_id('Database_Name')

	WHILE EXISTS(SELECT TOP 1 1 FROM @temp)
	BEGIN
	SET @id = (SELECT TOP 1 id FROM @temp)
	EXEC('kill ' + @id)
	DELETE @temp WHERE id = @id
	END