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 |
|
fqiao70
Yak Posting Veteran
52 Posts |
 Posted - 2003-06-25 : 16:47:40
|
| Hi, AllI have a sql server database, while using enterprise manager. I click the + to expand the objects, then I click users showing:Name Login Name Database Accessdbo barkra permitCOE\NET COE\NET permitbut I want COE\NET to be the database owner like Name Login Namedbo COE\NETHow can I do that??? why I coun't remove barkra this user??Thanks for you help!!!! |
|
|
Shastryv
Posting Yak Master
145 Posts |
Posted - 2003-06-25 : 17:09:21
|
| You need to change the database owner to COE\NET, inorder to show like that. Use sp_changedbowner to change it |
 |
|
|
fqiao70
Yak Posting Veteran
52 Posts |
Posted - 2003-06-25 : 17:51:35
|
| but it saysthe proposed new database owner is already a user in the database.???????????? |
|
|
|
Shastryv
Posting Yak Master
145 Posts |
Posted - 2003-06-25 : 18:02:11
|
| Before you change the owner of the DB, make sure the user is not in the DB, but in the public role of the master. |
|
|
|
fqiao70
Yak Posting Veteran
52 Posts |
Posted - 2003-06-25 : 18:32:52
|
| Thank you so much! it worked! |
|
|
|
|
|
|
Sql user problems