Post reply

Error returned when executing sp_helpdb

  • March 12, 2007 at 11:29 am

    #123147

    Hello,

    Can anybody explain me why does this error appier when i'm trying to execute the sp_heldb command.

    Thanks and regards,

    Jorge Mendes

    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.

    Thanks a lot.

    Regards,
    Jorge Manuel Mendes

  • March 12, 2007 at 11:45 am

    #694452

    Check the owner of the DB you're running this in.

    Chances are, the DB owner's Windows account has been deleted. Use sp_changedbowner to reset the owner to a valid Windows account.

  • March 12, 2007 at 12:52 pm

    #694470

    Thanks a lot.

    Now i've the results expected.

    Regards,

    Jorge Mendes

    Thanks a lot.

    Regards,
    Jorge Manuel Mendes

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply