How to delete user from a SQL server 2000 database in SQL server 2005? RRS feed

  • Question

  • Hi,

    I have a database created in server 2000, and now I have moved it to server 2005.

    All works do fine, but there is a user which cannot be removed.

    In the user properties window, the assigned schema is empty. The user is a db_owner of the database. When I was trying to update the user, it asked me for the login. The login is empty, but the field is disabled.

    So my question is, how to remove this user?

    Thank you.


    Thursday, February 1, 2007 2:43 AM


  • Hi,

    then it is probably an orphanded database user. You should use the

    sp_dropuser [ sp_dropuser ] 'user'


    HTH, Jens K. Suessmeyer.

    Thursday, February 1, 2007 8:22 AM