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
SQL-Server-Performance.com 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">quote:<hr height="1" noshade id="quote">Originally posted by Madhivanan 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 <hr height="1" noshade id="quote"></blockquote id="quote"> This is indeed the issue. There is no db owner. sp_changedbowner ‘sa' And the world is right, yet again. <img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ /> 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
http://www.SQL-Server-Performance.Com
This posting is provided â€œAS ISâ€ with no rights for the sake of knowledge sharing.

]]>