How to translate net_address

Does anyone know who to translate the column net_address
from master..sysprocess into it's corresponding ip address?
Thanks,
David.The net_address is the mac address of the machine
It corresponds to the Physical address returned from ipconfig /all
Rand
This posting is provided "as is" with no warranties and confers no rights.|||Is there a way to find the host, from the net_address? How?
>--Original Message--
>The net_address is the mac address of the machine
>It corresponds to the Physical address returned from
ipconfig /all
>Rand
>This posting is provided "as is" with no warranties and
confers no rights.
>.
>|||Not that I am aware of. There is no correlation between the mac address and
the ip address.
Rand
This posting is provided "as is" with no warranties and confers no rights.|||You can correlate the IP address back from hostname
select spid, dbo.fn_getIPaddress(hostname) as IPaddress
from sysprocesses
where spid > 50
GertD@.SQLDev.Net
Please reply only to the newsgroups.
This posting is provided "AS IS" with no warranties, and confers no rights.
You assume all risk for your use.
Copyright SQLDev.Net 1991-2004 All rights reserved.
"David Velasco" <anonymous@.discussions.microsoft.com> wrote in message
news:f02701c40c61$7cb7ae30$a301280a@.phx.gbl...
> Does anyone know who to translate the column net_address
> from master..sysprocess into it's corresponding ip address?
> Thanks,
> David.sql

How to Synchroize XML file with a tabe in SQL Server 2005?

Is there any inbuilt feature of SQL Server 2005 that will allow automatic synchronization of data in a XML file and its corresponding table in database, i.e. the data in XML file is pushed to table?

Have you considered using Scheduled Job? I mean you can import data from XML to database using Import/Export Wizard, with saving the process as a SSIS package. Then go to SQL Agent and create a job which executes the SSIS package, and you can schedule the job