login access problem

  • [SQL Server 2000 Enterprise]

    I just restored a user database to another server. I am trying to give the login name for that databaase access to it. There is an error message that "the user already exists" (which it does. It came with the restore).

    I try to drop the user but it owns some user defined data types, which I can't seem to change the owner of. I would drop the login and recreate it but it is in use by another database.

    any ideas how I can give this login access?

  • Check out this article. It should help.

    http://www.sqlservercentral.com/columnists/nboyle/fixingbrokenlogins.asp

    David

    David

    @SQLTentmaker

    “He is no fool who gives what he cannot keep to gain that which he cannot lose” - Jim Elliot

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply