Error running sp_helpdb | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Error running sp_helpdb

When I run sp_helpdb against the master (or any other DB for that matter) I get the following error: Server: Msg 515, Level 16, State 2, Procedure sp_helpdb, Line 53
Cannot insert the value NULL into column ‘owner’, table ‘tempdb.dbo.#spdbdesc_ 0010001A6EF’; column does not allow nulls. INSERT fails. The statement has been terminated. I have about 20 DBs on a SQL Server 2000 Standard Edition Instance with sp3a . There have been no changes made to the Server or the SQL Server Instance in quite some time. Can anyone tell me how I should proceed?????? Help !!

I did some poking around and noticed that when I look at the properties of my Model and msdb databases in Enterprise Manager, they BOTH have {unknown} for Owner !!?? that CAN’T be a good thing !!
I checked BOL for sp_changedbowner and it says that you can’t change the owner on master, msdb and ,model – so I’m a little leary to try it… Anyone have an suggestions? … please..
I must admit that I don’t know – but I’d try to set the owner of the master db to SA and then try again.
Oh, sorry, your second post wasn’t there when I started typing mine.
Shot in the dark: Check if there is other store procedure with the same name.
Luis Martin
Moderator One of the symptoms of an approaching nervous breakdown is the belief that one’s work is terribly important
Bertrand Russell
All postings are provided “AS IS” with no warranties for accuracy.
You need to change the owner of the database to sa
What happens if you run sp_helpdb ‘Master’? Madhivanan Failing to plan is Planning to fail
<blockquote id="quote"><font size="1" face="Verdana, Arial, Helvetica" id="quote">quote:<hr height="1" noshade id="quote"><i>Originally posted by Madhivanan</i><br /><br />You need to change the owner of the database to sa<br />What happens if you run sp_helpdb ‘Master’?<br /><br />Madhivanan<br /><br />Failing to plan is Planning to fail<br /><hr height="1" noshade id="quote"></font id="quote"></blockquote id="quote"><br /><br />This is indeed the issue. There is no db owner.<br /><br /><br />sp_changedbowner ‘sa'<br /><br />And the world is right, yet again. <img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ /><br /><br />It also means that someone potentially restored your database at some point and didn’t finish the ‘cleanup’ process.
I have seen similar issue on my development platform sometime ago, and when I have changed owner of master to SA again as per Haywood’s reference, it worked. Satya SKJ
Contributing Editor & Forums Moderator
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.