Atif
Hall of Fame
Points: 3578
More actions
July 28, 2008 at 10:34 pm
#194960
Is there any way to log the IP address of client machine that is accessing the database server, through T-SQL.
Regards
DBDigger Microsoft Data Platform Consultancy.
VastSQL
SSC-Dedicated
Points: 36097
July 28, 2008 at 11:13 pm
#849562
Try using
xp_cmdshell 'netstat -an'
xp_cmdshell 'ipconfig /all'
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply