Post reply

Can not Check properties of DB

  • November 6, 2008 at 7:38 am

    #124604

    I cud not check properties of my database when i right click on DB which is in read only mode but i can see for other db's which are also in readonly mode.

  • November 6, 2008 at 7:47 am

    #894877

    Do you have access to this DB?

    The_SQL_DBA
    MCTS

    "Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives."

  • November 6, 2008 at 7:58 am

    #894892

    I am the sysadmin on the server but still says

    " Property owner is not available for database mydb . This property may not exist for this object or may not retreiveable due to insuffciant access rights "

    I tried making it read write but still the same error.

  • November 6, 2008 at 8:05 am

    #894904

    Assuming you have correct access... There may be issue with coaliation also... However I would recomend to use below steps:

    1. Verify your access

    2. Run sp_helpdb on the DB


    CDBA

  • November 6, 2008 at 8:08 am

    #894908

    How cud i verify my access and how can i make an existing user as sysadmin.

Viewing 5 posts - 1 through 4 (of 4 total)

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