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 |
|
cezar
Starting Member
1 Post |
 Posted - 2006-01-20 : 21:03:11
|
| Hello,I am trying to change the database owner and when I run commandUSE databaseEXEC sp_changedbowner 'user'GOI get error message "Msg 15110, Level 16, State1, Line1The proposed new database owner is already a user or aliased in the database."I am running SQL 2005 on Windows 2003 with SP1 installed. I installed the application that creates the database and a user but doesn't make that user an owner the database.Thanks in advance for any help.Zvonimir |
|
|
cshah1
Constraint Violating Yak Guru
347 Posts |
Posted - 2006-01-21 : 16:39:33
|
| 'user' cannot become the owner of the current database if it already has access to the database through an existing alias or user security account within the database. To avoid this, drop the alias or 'user' within the current database first. |
 |
|
|
|
|
|
change database owner