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 |
|
vadood
Starting Member
7 Posts |
 Posted - 2003-05-16 : 01:09:30
|
| Hi,There is a Management subtree in Enterprise manager that one can examine current server activity and process info. I want to access this data through code and be able to do the same actions available there (kill process, for example). First I thought I could do this using SQL-DMO but could not find anything. Any comments? |
|
|
pmr
Starting Member
37 Posts |
Posted - 2003-05-16 : 04:55:21
|
| Look up "KILL" in Books OnlinePeter |
 |
|
|
Andraax
Aged Yak Warrior
790 Posts |
Posted - 2003-05-16 : 06:53:34
|
| ... and look at sp_who, to see the processes. |
|
|
|
vadood
Starting Member
7 Posts |
Posted - 2003-05-17 : 09:23:47
|
| thank you, I finally did it. I just wanted to use SQL-DMO to do it through VB code. The SQLServer object has an Enumprocesses method which lists all processes and full info for them.vadood |
|
|
|
|
|
|
Get current server activity