title: How to get user details from SQL Server session like user ip,host name etc
body: <p>I want to get user all possible details from SQL Server session like user ip, host name etc. I have searched about <code>sp_who</code>. Any expert can guide me how I can achieve this? I have searched a lot but not found master piece</p>