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