Posted by Gerd on 03/29/07 06:25

Hi all,

I'm having a problem restoring backup from 2000 to 2005. The actual
restore process went ok. However, the database user of the restored
database is missing a Login Name. I've made sure that the Login Name
is created in 2005. Also tried deleting the user, but couldn't the
user is db owner. Is there any way that I can assign a Login Name for
this database user or maybe drop this user and assign another one?

Regards,
Gerd

• Next in forum: Run query based on values in another table
• Prev in forum: Re: Newbie on permissions: ADO.NET, C++.NET, SQL SERVER 2005 EXPRESS, Visual Studio 2005
• Thread view: Restoring backup from SQL 2000 to SQL 2005 but login name is missing

[Reply to this message]