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:29:59
|
| I already made this topic to the new to sql topic! (sorry admins)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. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-12-12 : 12:48:27
|
| You can use the hostname column to determine the originating host.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
SQL 2K5 Active Monitor