Printable View
I was trying to clean the Logins and saw some userid that were old then when I tried to delete I got this message:
Error 15174:Login 'userid' is aliased or mapped to a user in one or more database(s). Drop the user or alias before dropping the login. Database name: ABC
Use sp_dropuser in database ABC to drop the user first, then drop the login.
It worked on all except one that says:
User 'userid' does not exist in the current database.
I tried deleting from Security and got this message "the specified @owner_login_name('userid') does not exist.
Do you see the user in sysusers table?
If yes, then it may be an alias in the database. Try sp_dropalias.
What is this alias in the database, i got to know abt this 1st time.
Apart from sysuser where i can see database alias.
Don't revive a 8 years old thread if you have a question.
Database alias was a concept in SQL 6.x, you should not use it anymore.