SQL 2005 diagram

• degrem_m

  SSCommitted

  Points: 1519

  More actions

  April 5, 2006 at 12:40 pm

  #114259

  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

• Prema sambandam

  SSCommitted

  Points: 1825

  More actions

  April 6, 2006 at 8:45 am

  #631244

  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

• ARUL-285958

  Ten Centuries

  Points: 1081

  More actions

  April 7, 2006 at 12:03 pm

  #631566

  To work with compatible level, use the below SP.

  sp_dbcmptlevel

  ---

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