Is there a task manager of sorts for SQL Server 2008 and on?

Question

Is there a task manager of sorts for SQL Server 2008 and on? A way to see what SQL server is doing, kill runaway queries, etc...

Answer 1

select * 
from sys.sysprocesses

Should show you the processes running. Kill tasks is the

KILL <task> 

command

Note, this view (master.dbo.sysprocesses) is as a backward compatible view, so it might not be here in future SQL releases