April 5, 2006 at 12:40 pm
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 ?
degrem_m
Degremont
April 6, 2006 at 8:45 am
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
April 7, 2006 at 12:03 pm
To work with compatible level, use the below SP.
sp_dbcmptlevel
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply