Results 1 to 6 of 6
  1. #1
    Join Date
    Dec 2001
    Location
    USA
    Posts
    13

    Unanswered:

    That is a user role, or user account error, and it probably already exists in the current system.

    If you go to the user section of the db that you just restored, and delete all of the users, then go to the security options and allow these users to see it again, it should fix your problem.

    There is a script somewhere that will resolve this, i will try to find and post.

    Scooter McFly

  2. #2
    Join Date
    Mar 2004
    Posts
    4
    hi,
    but how i ll remove dbo in database.it is not removing anyway showing error that:
    The selected use canot be dropped because the user owns objects
    -Ashwini
    Originally posted by scootermcfly
    That is a user role, or user account error, and it probably already exists in the current system.

    If you go to the user section of the db that you just restored, and delete all of the users, then go to the security options and allow these users to see it again, it should fix your problem.

    There is a script somewhere that will resolve this, i will try to find and post.

    Scooter McFly

  3. #3
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    I would suggest EXECUTE sp_change_users_login 'Auto_Fix' myself.

    -PatP

  5. #5
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    If you want to drop a user from a db where it owns objects, you can change object ownership to dbo (or any other user - NOT RECOMMENDED) and go on with the drop.

  6. #6
    Join Date
    Mar 2004
    Posts
    4
    yaa,solved

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •