Getting the User IP Address

[SSDeshpande]

Hi,
I have a trigger sitting on a table that insers the old values of the updated row to a log table. I need to push the IP Address of the user who inserted/updated the row. How can i get this in SQL Server 2000???

Please let me know ASAP

Thanks.
Sudhanshu

 

[nikhilparchure]

The sysprocesses system table could be of your use.
pls se BOl for more details