<div>
right-click the instance then click activity monitor is what I was looking for.
</div>


right-click the instance then click activity monitor is what I was looking for.

<div>
<div class="content wysiwyg-content">
back in sql server 2000 the enterprise manager had section labelled activity/process info where I could see and kill processes. In sql server 2005/2008 I can write a query to see this but where can I find the GUI like in sql server 2000?
</div>
</div>


back in sql server 2000 the enterprise manager had section labelled activity/process info where I could see and kill processes. In sql server 2005/2008 I can write a query to see this but where can I find the GUI like in sql server 2000?

where is current activity/process info in sql server 2005/2008

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.