How do you get the username of the sql server of the current command in the CLR trigger?

Question

I know that SqlContext.WindowsIdentity returns the current user executing the command (in the CLR trigger), however this only works for authenticated Windows users. How can I get the username if he is instead a user of the SQL server? Any help is appreciated.

Answer 1

Try using the function SUSER_NAME()on the SQL server. This will return the current user.

Answer 2

Try using SYSTEM_USER.

SELECT SYSTEM_USER

Answer 3

, .

( #):

SqlConnection connection = new SqlConnection("context connection=true");