Rewrite a Cursor

Try this,

DECLARE @SQL VARCHAR(8000)
SELECT @SQL = COALESCE(@SQL,'') + 'Kill ' + CAST(spid AS VARCHAR(10)) + '; '
FROM sys.sysprocesses
--WHERE DBID = DB_ID('X')
PRINT @SQL
--EXEC(@SQL)

---

Regards, RSingh