March 5, 2009 at 12:29 am
Hi all,
I have just installed SQl Server 2008 in my machine. The problem i am not able to find the Acitivty monitor (in SQL Server 2005 which was show under management) in SQL Server 2008.
i need to kill a process during restoration. PLease Help
Thank You
Ansar
March 5, 2009 at 12:55 am
ansar.vma (3/5/2009)
Hi all,I have just installed SQl Server 2008 in my machine. The problem i am not able to find the Acitivty monitor (in SQL Server 2005 which was show under management) in SQL Server 2008.
i need to kill a process during restoration. PLease Help
Thank You
Ansar
Do you really need activity monitor to kill the process? Have you tried sp_who2 to see the acitvities? When you have found your process ( using dbcc inputbuffer(theSpidYouWantToKill) ) , you only need to use KILL theSpidYouWantToKill
/Håkan Winther
Senior Development DBA
/Håkan Winther
MCITP:Database Developer 2008
MCTS: SQL Server 2008, Implementation and Maintenance
MCSE: Data Platform
March 5, 2009 at 12:11 pm
The other question:
1. Way
In toolbar the icon right of the "Print" icon is the "Activity Monitor"
OR
Right click on the server within the "Object Explorer" -> "Activity Monitor"
Greets
Flo
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply