SQL 2005 diagram

  • Hi,

    I connected to  Microsoft SQL Server Management Studio. And it's ok. but when I tried to create a diagram, I have this message.

    ------------------------------

    Database diagram support objects cannot be installed because this database does not have a valid owner.  To continue, first use the Files page of the Database Properties dialog box or the ALTER AUTHORIZATION statement to set the database owner to a valid login, then add the database diagram support objects.

    I  am connecting with count administrator and windows authentification.

    Wich user, can I grant access ?


    Kindest Regards,

    degrem_m
    Degremont

  • Hi:

    I got the same issue. I resolved in this way.

    Change the compatability level to sql server 2005(90)

    Now you can create database diagram

    Thanks,

    Prema

  • To work with compatible level, use the below SP.

    sp_dbcmptlevel


    Get busy living ....or get busy dying....

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

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