August 27, 2009 at 1:18 am
Server: Msg 515, Level 16, State 2, Procedure sp_helpdb, Line 53
Cannot insert the value NULL into column 'owner', table 'tempdb.dbo.#spdbdesc___________________________________________________________________________________________________________0001000000DA'; column does not allow nulls. INSERT fails.
The statement has been terminated.
August 27, 2009 at 3:07 am
kiranmca24 (8/27/2009)
Server: Msg 515, Level 16, State 2, Procedure sp_helpdb, Line 53Cannot insert the value NULL into column 'owner', table 'tempdb.dbo.#spdbdesc___________________________________________________________________________________________________________0001000000DA'; column does not allow nulls. INSERT fails.
The statement has been terminated.
which account owns the database that you are trying to run sp_helpdb against. if it comes back as either 'unknown' or the login no longer exist.
do this
use [databasename]
EXEC sp_changedbowner 'sa'
and then run your sp_helpdb again.
if any of the system databases have an invalid owner, you will need to change the owner to sa
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply