H.79

@SolomonRutzky - Write a custom query that joins tables based on the SID, and the user will know who and what is talking to his sql server. I see things like this all the time as a Data and AI consultant for Microsoft.

@SolomonRutzky - There is certain information that lives in sys.syslogins that you can't get anywhere else, and is used by the beloved sp_help_revlogin stored proc which uses sys.syslogins - I know what the link says, but it's not going anywhere.

@user9516827 - NICE!

@SolomonRutzky - Are you suggesting that sys.syslogins is deprecated?

Do a select * from sys.syslogins where sid = {copy and paste the sid from line 1} -- What do you get from that query?

What's the value for the sid column?