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
No comments:
Post a Comment