Browse by Tags

• kpid
• processes
• sp_who2
• spid
• sql server
• sysprocesses
• transaction log
• transactions

SQL Server - Kill a KILLED/ROLLBACK status process without restarting Server or SQL services?
06 May 08 01:02 AM | SQL Master | 2 Comments   

This may be the typical situation within your database environment where the you might have killed a SPID (Process) that has been running for long time, without knowing the ROLLBACK operations for such processes. Say if you are executing a stored procedure Read More...

Filed under: sql server, spid, transactions, transaction log, processes, kill, rollback, sysprocesses, kpid, sp_who2