|
Posted by kb on 03/29/07 07:05
> 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
--
Tom
http://kbupdate.info/
Navigation:
[Reply to this message]
|