SQL Server Performance

Activity Monitor in SQL Server 2008

Discussion in 'SQL Server 2008 General DBA Questions' started by ansarvm, Oct 30, 2009.

  1. ansarvm New Member

    Hello All,
    I have to know about how to kill a process in SQL Server 2008.
    While restoring a database in SQL, if that database is using an another user, then i had to kill that user using Activity Monitor(under managemnt) in SQL Server 2005. But when i a Changed to SQL Server 2008 i cant do that. I have found Activity monitor, but it wont showing the database name to kill.
    So please help me....
  2. melvinlusk Member

    You can run this query, and it will show you all running processes:
    sp_who2 active
    Find the value in the SPID column for that particular process, and kill it with this:
    kill 1234
    (where 1234 is the SPID value)

Share This Page