house9

random code and what not

Procedure sp_droplogin, Line 93 Login is aliased or mapped to a user in one or more database(s)

Trying to remove a MSSQL login from a database server, recieve the following eror

Msg 15175, Level 16, State 1, Procedure sp_droplogin, Line 93
Login ‘qa’ is aliased or mapped to a user in one or more database(s). Drop the user or alias before dropping the login.

Solution: run this command to determine what alias or groups the login is associated with and then remove those; might be nice if they just added this to the error message?

sp_helpuser ‘qa’