Property Owner is not available for Database

• little1

  Say Hey Kid

  Points: 706

  More actions

  December 17, 2008 at 8:56 am

  #199012

  SQL 2005

  Im getting the error below on 5 out of 8 of my clients databases when trying to access the properties, I have no problem access the properties of the other 3 databases;

  "Property Owner is not available for Database '[AdhocReportsDB]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights".

  I logged in as sa to see if i could check the properties but still the same error.

  Anyone seen this or can help?

  Thanks

• Suresh B.

  SSC-Insane

  Points: 22986

  More actions

  December 18, 2008 at 12:30 am

  #914322

  Set the database owner using sp_changedbowner

  For example:

  use DatabaseName

  go

  sp_changedbowner 'sa'

  go

  After that you will be able to access the database properties.