Who Logged in by the SQL server 'sa' Credential?

Question

SQL server is connecting by LAN. i want to know who logged in SQL server with LAN IP and individual machine IP address(IPV4). ex- select . * from .... ???? Please Help...

Nitin Sontakke · Answer

The following will explain each column of the output: https://msdn.microsoft.com/en-IN/library/ms179881.aspx You will probably have to look for hostname column.

Nitin Sontakke · Answer

select * from sys.sysprocesses where loginame = 'sa'

Joginder Banger · Answer

Hi roy i think this some difficult question i searching on google behalf on you. I think this link some help you.. http://weblogs.sqlteam.com/peterl/archive/2010/03/20/Get-client-IP-address.aspx

Nirmal Roy · Answer

Dear Nitin Sontakke  select * from sys.sysprocesses where loginame = 'sa' but here is no LAN IP and individual machine IP address(IPV4). i want that ip.