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 |
|
CanadaDBA
583 Posts |
 Posted - 2006-06-02 : 14:48:11
|
| I have a problem in one of the databases on my test server. In EM when I check the users under the database, there is "dbo" user with "Testuser" as login name. Testuser is a login name and I don't know how this had happened. I tried to drop dbo in the database but it doesn't let me. Also, tried to drop the Testuser from security logins folder but still faild. How can I fix the problem?Thanks,Canada DBA |
|
|
MuadDBA
628 Posts |
Posted - 2006-06-02 : 15:15:49
|
| Check out sp_changedbowner stored procedure to chang the DB owner back to sa (or whoever should be the db owner) |
 |
|
|
|
|
|
DBO