cancel
Showing results for 
Search instead for 
Did you mean: 

Interactive Login Username

3,734

If two Windows user accounts (jsmith and mjones) were mapped to the same database user account (demo) using interactive logins, is there a way to tell them apart if both are connected? Most of what I am finding just shows demo twice.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member

Check the connection properties, OSUser should be what you're looking for:

SELECT CONNECTION_PROPERTY ( 'OSUser' );

Connection properties

Answers (1)

Answers (1)

Former Member

Connection Properties will show IP address of the machine each one is connected from, which might help. If they're coming from a Terminal Server, not sure how you would distinguish them.