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 |
|
Sarat
Constraint Violating Yak Guru
265 Posts |
 Posted - 2002-04-23 : 19:44:10
|
| Hi! Every dbo user has 'sa' login attached to it in all the databases but somehow for my prodution DB, the dbo doesnot have 'sa' attached to it. The only thing we did was to refresh the PeopleSoft database on SQL Server with AS400 PSoft database for migration purposes.How do I fix this?I tried:sp_change_users_login 'Update_One', 'dbo', 'sa'but it didn't workWhat can I do?Thanks,Sarat |
|
|
Sarat
Constraint Violating Yak Guru
265 Posts |
Posted - 2002-04-23 : 20:10:57
|
| I was able to make sa as dbo for the production db.I realize I cannot use the previous mentioned procedure for user dbo and login sa.EXEC sp_changedbowner 'sa'Thanks |
 |
|
|
|
|
|
dbo user lost its login