on 2012 May 03 4:30 PM
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.
Request clarification before answering.
Check the connection properties, OSUser should be what you're looking for:
SELECT CONNECTION_PROPERTY ( 'OSUser' );
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
61 | |
8 | |
7 | |
6 | |
6 | |
5 | |
4 | |
4 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.