Unanswered: how to Select current client IP Address using T-SQL command ?
I have problem to find Current IP address for client computer that have a connection to Specific DataBase Server .I can only know the IP Address of DataBase Server but not current client user IP address that I am seeking to find it
,How can I do this by using T-SQL command?
Please write full T-SQL code .
well, u can use xp_cmdshell 'netstat -an' .Thats a way to see the client ip address.But I would like to hear better answer than this one.
To find server ipaddress see this link
and to store ip address in tables see this link
Success is the ability to go from one failure to another with no loss of enthusiasm.
- Sir Winston Churchill