General information
Forum:
Microsoft SQL Server
Title:
Restore a database on another server
Hi,
I have a little problem this morning when I trying to restore a database on another server.
First of all, I have a database called 'bdX' and the dbo user mapped with Login1.
I backed up and restored the database. When I ran this command:
exec sp_change_users_login 'Update_One', 'dbo', 'Login1'
I got this message...
Server: Msg 15287, Level 16, State 1, Procedure sp_change_users_login, Line 38
Terminating this procedure. 'dbo' is a forbidden value for the login name parameter in this procedure.
Why ? and What can I do ? is it an important message to solve...
Thank in advance.
Dave Sonier
Technologies Nter
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only