Error returned when executing sp_helpdb

• Jorge Manuel Mendes

  Mr or Mrs. 500

  Points: 521

  More actions

  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

• PW-201837

  SSC-Insane

  Points: 20805

  More actions

  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.

• Jorge Manuel Mendes

  Mr or Mrs. 500

  Points: 521

  More actions

  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