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. |
Check the connection properties, OSUser should be what you're looking for: SELECT CONNECTION_PROPERTY ( 'OSUser' ); |
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. |