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 |
|
SQLServerDBA_Dan
Aged Yak Warrior
752 Posts |
 Posted - 2001-08-13 : 17:07:52
|
| If the hostname and application_name are not listed (for some of the spids) in the sysprocesses table and you have about 200 users, the question is:How can you use the NET_Address column to get to the user with the run-away process? BOL says that the NET_ADDRESS column in the sysprocesses table is a unique address from the NIC... Knowing this, I would assume that it could easily be traced back to a user's workstation.DanielSQL Server DBA |
|
|
|
|
|
Let's see how smart you peeps are...