🚀 go-pugleaf

I am running into a situation where the net_address field is coming up
for more records than it should.  According to MS documentation the
net_address field in the master..sysprocesses table in MS SQL 2000 is
supposed to be the NIC address [MAC].  Depending on the number of
spids from each machine, you can get an idea of how many processes
belong to the same NIC card.  Currently though I have one MAC address
which shows 40 processes attached to it.  The users, I know are logged
in from multiple floors in the building so there is something wrong.

Has anyone seen this happening?

Here is the query which tells me how many processes per NIC card.

select net_address, count(distinct hostname)
from master..sysprocesses p
group by net_address

If I were to run the following I get one row.


select net_address, count(distinct hostname)
from master..sysprocesses p
group by net_address
having count(distinct hostname)<>1

which is 
net_address     (No Column Name)
---------------------------------
009027C2C095	40

Does anyone know what's going on here?