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 |
|
lightsql
Starting Member
17 Posts |
 Posted - 2009-05-26 : 23:25:56
|
| One of the server we have is hosting a sql instance with all of its databases having an invalid database owner. This issue has caused sp like sp_helpdb to produce error messages. I can use sp_changedbowner to define the db owner for each databases problem are system databases( master, model, tempdb).The database owner of master, model and tempdb cannot be replaced as far as i know but do you know a workaround to this issue aside from rebuilding the server =)Thanks guys! |
|
|
|
|
|
Fixing database owner issues