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...