error 15023 after restore db on different server (user dbo)

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 McFlyhi,
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|||http://support.microsoft.com/default.aspx?scid=kb;en-us;819261 to resolve the issue.|||I would suggest EXECUTE sp_change_users_login 'Auto_Fix' (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_sp_ca-cz_8qzy.asp) myself.

-PatP|||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.|||yaa,solved