Hi, Thanks for your reply..

sysusers only shows the local users but I want the details of users in the complete AD who are accessing the database and whether they are...

There is a table called sysxlogins but that only gives the logins details.

But, I need a query that gives me a complete list of users who connect to the database...