Category: INACTIVE SPID

KILL ALL INACTIVE SPIDS

Please use this only if you know what you are doing. I have intentionally commented the kill command. If some one knows how to uncomment it, only then, this script will work. —————————- —————————- First run this to find the offending database….. —————————- —————————- SELECT DB_NAME(dbid) as ‘Test’, COUNT(dbid) as ‘Total Connections’ FROM master.dbo.sysprocesses WITH
Read More »