Pages

Saturday, September 21, 2013

SQL SERVER – Cursor to Kill All Process in Database | Journey to SQL Authority with Pinal Dave

When you run the script please make sure that you run it in different database then the one you want all the processes to be killed. CREATE TABLE #TmpWho (spid INT, ecid INT, status VARCHAR(150), loginame VARCHAR(150), hostname VARCHAR(150), blk INT, dbname VARCHAR(150), cmd VARCHAR(150)) INSERT INTO #TmpWho EXEC sp_who DECLARE @spid INT DECLARE @tString VARCHAR(15) DECLARE… Continue Reading...

Source: SQL SERVER – Cursor to Kill All Process in Database | Journey to SQL Authority with Pinal Dave