Kill Multiple SPIDs

Quite a handy script if you want to clear out ALL spids connected to a database. USE master go DECLARE @dbname sysname SET @dbname = ‘yourdbname’ DECLARE @spid int SELECT @spid = min(spid) FROM master.dbo.sysprocesses WHERE dbid = db_id(@dbname) WHILE @spid IS NOT NULL BEGIN EXECUTE (‘KILL ‘ + @spid) SELECT @spid = min(spid) FROM [...]

Read Full Post »