Posted by kb on 03/29/07 07:08

>> 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?
>
> use system stored procedure:
> sp_change_users_login

here is online documentation:

SQL Server 2005 Books Online > sp_change_users_login:
http://msdn2.microsoft.com/en-us/library/ms174378.aspx


--
Tom
http://kbupdate.info/

• Next in forum: Re: Run query based on values in another table
• Prev in forum: Re: Restoring backup from SQL 2000 to SQL 2005 but login name is missing
• Thread view: Re: Restoring backup from SQL 2000 to SQL 2005 but login name is missing

[Reply to this message]