Browse by Tags

SQL Server - Kill a KILLED/ROLLBACK status process without restarting Server or SQL services?

Published 6 May 8 3:2 AM | SSQA.net

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...

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

SQL Server: Quick way to find Active & idle connections on a SQL instance

Published 2 May 8 4:32 AM | SSQA.net

Using SQL Server 2005 you can take help of DMV - sys.dm_exec_connections that will give server-level information about the connections. In the olden days usage of sysprocesses system table used to be heavy and same approach can be achieved by using system...

Filed under: sql server, dmv, transaction, connections, tsql, sysprocesses, active