Adding users to SQL-Server

[brouse]

Our product uses MSDE or MS-SQL Server 2K. It does not use SQL logins - it is strictly NT logins. Our product DB has a Users table that contains all the NT logins that have permission to use the product.

I have written a stored procedure that grants new users permission to the SQL-Server, grants them permissions to the DB, adds them to a role (to grant them permission to the objects they'll need) and then adds them to the product's Users table. I use the sp_GrantLogin and sp_GrantDBAccess stored procedures to perform those first two steps.

The problem occurs if the user already has permissions to the SQL-Server or the DB because of an alias, or because they are members of a group that has permissions (such as the local Administrators group). The two stored procedures above will throw an error if this occurs. However, the result is only pass/fail (0 or 1), so I can't tell programmatically if the failure is due to the user already being in the system (due to an alias) or for some other reason.

How can I test (using SQL Script) to see if an NT Login already has permissions to the server and to a particular DB?

Thanks...

[brouse]

Let me simplify the question...

When executing "sp_GrantLogin", I get an error: "The login already has an account under a different user name"

How can I find out what that other user name is?

Thanks,