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 |
|
admin001
Posting Yak Master
166 Posts |
 Posted - 2003-06-07 : 02:49:54
|
| Hi ,I have restored some databases from one server say server A to another server B through bak files . But when I check the users in the restored database of server B , it does not show user name as dbo , login name as 'sa ' with database access as permit . While on the source server A it shows and has to be there . The strange thing is that , it does not display for some databases while for some DB's they have a DBO . Any problems could have happened during the restore process ? In fact the restore process went smoothly without any issues . I am not creating any database on server B prior to restore . I am unable to fugure this specific problem and would require your suggestions . Thanks |
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
Posted - 2003-06-07 : 12:46:05
|
| After a restore like this, it is always a good practice to run the following procs:1. sp_change_users_login2. sp_changedbownersp_changedbowner will fix the issue you are having. Check both of these out in BOL for syntax, etc.-ec |
 |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2003-06-07 : 18:45:58
|
| You should use my script. You can find it in the scripts forum.-Chadhttp://www.clrsoft.comSoftware built for the Common Language Runtime. |
|
|
|
eyechart
Master Smack Fu Yak Hacker
3575 Posts |
|
|
|
|
|
DBO login after DB restore .