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 |
|
rb1373
Yak Posting Veteran
93 Posts |
 Posted - 2005-03-29 : 23:43:53
|
| When I execute sp_helpuser in one of my databases, I see username dbo is assigned to loginname 'domain\someuser'. In my other databases, dbo is assigned to loginname sa. How do I reassign dbo to sa?Thanks,Ray |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2005-03-30 : 01:58:02
|
| use databasenamegosp_changedbowner 'sa'--------------------keeping it simple... |
 |
|
|
|
|
|
resassign dbo to sa