Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-09-14 : 07:00:10
|
| Amir writes "I have a Database with a user named "usr" witch ownes all tables in that Database.This user is associated to a login in server named "lgn".When I get a full backup from db on disk and restore it in another server, I can not match the user with pre-created login in the new server.I mean even if I create a login named "lgn" in the new sql server and then restore the db, SQL server dosen't match the user with that login.So later on I can not create new tables with the "usr" ownership.Because in restored db, there is no login associated to the "usr".help please." |
|
|
mr_mist
Grunnio
1870 Posts |
Posted - 2005-09-14 : 07:46:49
|
| You need to use sp_change_users_login to fix the problem.-------Moo. :) |
 |
|
|
|
|
|
Restore same thing