sysprocesses net_addess change when not on network

• Robert Mizzaro

  SSC Rookie

  Points: 34

  More actions

  January 14, 2003 at 12:17 pm

  #64625

  I am running an instance of SQL Server 2000. The Net_Address in sysprocesses is different when I am not connected to a network. However, when I am connected to

  any network, Net_Address matches the Physical Address of the computer on which I am running the SQL Server instance.

  Can anyone provide an explanation of why SQL Server would identify an address that does not match the physical address of the computer running the instance.

  Also, can this be avoided? I have a program that checks the address that SQL Server provides.

• Antares686

  SSC Guru

  Points: 125444

  More actions

  January 14, 2003 at 3:14 pm

  #446341

  What is the address? Maybe 127.0.0.1 which is the loopback address or something similar.