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 |
|
Sitka
Aged Yak Warrior
571 Posts |
 Posted - 2003-11-19 : 11:14:27
|
| In EMuser is dbologin is blankthis shows up that way to when interpretingsp_helplogins 'sa'(db dosen't appear in the list)sp_helpuser 'dbo'(dbo has a login of null for that db)what is this condition called?Tenacious O |
|
|
chadmat
The Chadinator
1974 Posts |
Posted - 2003-11-19 : 11:40:22
|
| The User is orphaned. Usually the result of attaching a DB on a new server.You can fix it by running sp_changedbownwer 'sa'-Chadhttp://www.clrsoft.comSoftware built for the Common Language Runtime. |
 |
|
|
Sitka
Aged Yak Warrior
571 Posts |
Posted - 2003-11-19 : 11:45:46
|
| Thanks.Tenacious O |
|
|
|
|
|
|
orphaned dbo?