Home Forums SQL Server 7,2000 Administration Error 15023: “User already exists in current database” RE: Error 15023: “User already exists in current database”

  • Once you've confirmed he doesn't own any more objects, you can delete him from the sysusers table on the relevant database

    NB. You must allow ad hoc modifications to the server first. Make sure you change this back straight away.

    Once that row is deleted you can add the user login correctly.

    Eoin