After executing this I got a list of all users and their database access and roles. Then I realized something was missing. I used to login to sql server 2000 and execute sql statements. I am local system admin. I can see a login named Builtin\Administrator under security and this has access to all database as db_public and db_owner.

Here i have 2 questions

1. Why is Builtin\administrators not listed ? doest that mean that the procedure and query given in the link is wrong.

2. I can see certain users who has access to few of the databases. But these users are not in the login section under security. How can a user have access to database without a login ?

I would be extremely thankful to you could clarify my queries.

Thanks