Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
mikebird
Aged Yak Warrior
529 Posts |
Posted - 2009-09-02 : 09:39:50
|
Please remind me the query to run to see what's running against a database so I can kill my queries that are hanging / locked / taking too long on this 2000 system.I can't run Activity Monitor from SSME 2005 so probably don't have the privs but I'd like to take a look if I can.select * from sys.dm_sessions... etc I remember... |
|
TG
Master Smack Fu Yak Hacker
6065 Posts |
Posted - 2009-09-02 : 09:59:19
|
try:exec sp_who2 activeBe One with the OptimizerTG |
|
|
mikebird
Aged Yak Warrior
529 Posts |
Posted - 2009-09-02 : 10:23:58
|
Spot-on. Thanks |
|
|
mikebird
Aged Yak Warrior
529 Posts |
Posted - 2009-09-02 : 10:27:01
|
It's the spid to kill by, yes? |
|
|
|
|
|