SQL Server Performance

migrating logins 2000 -> 2005

Discussion in 'SQL Server 2005 General DBA Questions' started by acki4711, Apr 12, 2007.

  1. acki4711 Member

    Hi all,
    I have detached/attached a sql 2000 db to a sql2005 db.
    The db contains one db user who is dbo in that db.
    With sp_change_users_login I was able to create the missing sql login on sql 2005 server but the mapping between the login and the db was not made and cannot be made manualy -> user already exists in db ???
    I even cannot drop user in db -> owns shemas

    How to get around this ?
    TIA
    acki




  2. madhuottapalam New Member

  3. satya Moderator

    What was the specific error you are getting when trying to?
    I beleive Madhu's link should get you what you are looking.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

Share This Page