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 |
|
m.anthis
Starting Member
2 Posts |
 Posted - 2014-12-12 : 04:28:08
|
| Hello people. New here, glad to meet you.I have a simple question (i think), i am trying to developa query so i can see all the processes so after i can kill each oneis making a problem to the others trying to be processed from the server. The problem is that i can do that with the active monitor but i cannot see from whom is each one process. All the clients are connecting with the sa user (sql authentication) so it would be great if i could see from which computer name each process is made or from which user or ip address. I dont know if all that im asking are clear enough for you guys. Please advice. Thank you very much. |
|
|
ahmeds08
Aged Yak Warrior
737 Posts |
Posted - 2014-12-12 : 05:21:10
|
| you can get the host name from select * from sys.sysprocessesJaveed Ahmedhttps://www.linkedin.com/pub/javeed-ahmed/25/5b/95 |
 |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-12-12 : 08:55:18
|
| I'd immediately disable the sa account. Big security risk there. |
|
|
|
|
|
|
SQL 2K5 Active Monitor