Get login name in SQL SERVER

Question

I have an orphan user in sql server and I want to get the login name not the user name because they are not the same, I didn't find a solution that correspond to my needs.

Answer 1

I believe that this is what you need:

SELECT ORIGINAL_LOGIN()

Answer 2

You should be able to get it using :

SELECT suser_name()

Docs Link : https://learn.microsoft.com/en-us/sql/t-sql/functions/suser-name-transact-sql