Thanks Barry,

You pointed me in the right direction, in regards to sQL2000 I was able to use:

xp_CmdShell 'ipconfig|find "IP Address"'

I had to insert the output into a table variable and use RIGHT(Rtrim(ipaddr),15) to get just the "IP Address"