Null DB Owner

I have a handful of databases that for some reason, have a null dbowner. I
exec sp_changedbowner 'sa' on one of the databases, now when I run sp_helpdb
i get the following error:
Server: Msg 515, Level 16, State 2, Procedure sp_helpdb, Line 53
Cannot insert the value NULL into column '', table ''; column does not allow
nulls. INSERT fails.
The statement has been terminated.
How do I go about changing the owner if sp_changedbowner didn't correct the
problem?
Thanks,
MorganMorgan,
I had a similar problem once and fixed it through a two-step process. Try
this:
exec sp_changedbowner 'SomeOtherLogin' --login must exist, of course
go
exec sp_changedbowner 'sa'
go
If this does not work, careful surgery on the system tables might fix it,
but that is to be avoided.
Russell Fields
"Morgan" <abcd@.senditon.com> wrote in message
news:uQDg7Rc6DHA.2712@.tk2msftngp13.phx.gbl...

quote:

---

> I have a handful of databases that for some reason, have a null dbowner. I
> exec sp_changedbowner 'sa' on one of the databases, now when I run

---

sp_helpdb

quote:

---

> i get the following error:
> Server: Msg 515, Level 16, State 2, Procedure sp_helpdb, Line 53
> Cannot insert the value NULL into column '', table ''; column does not

---

allow

quote:

---

> nulls. INSERT fails.
> The statement has been terminated.
> How do I go about changing the owner if sp_changedbowner didn't correct

---

the

quote:

---

> problem?
>
> Thanks,
> Morgan
>

---

|||Hi Russell,
Thanks for the tip. I went through and assigned to another user, then
reassigned back to sa and that appears to have fixed it.
Thanks,
Morgan
"Russell Fields" <RussellFields@.NoMailPlease.Com> wrote in message
news:ecXvClc6DHA.3704@.tk2msftngp13.phx.gbl...

quote:

---

> Morgan,
> I had a similar problem once and fixed it through a two-step process. Try
> this:
> exec sp_changedbowner 'SomeOtherLogin' --login must exist, of course
> go
> exec sp_changedbowner 'sa'
> go
> If this does not work, careful surgery on the system tables might fix it,
> but that is to be avoided.
> Russell Fields
> "Morgan" <abcd@.senditon.com> wrote in message
> news:uQDg7Rc6DHA.2712@.tk2msftngp13.phx.gbl...
I[QUOTE]
> sp_helpdb
> allow
> the
>

---