Monday, March 19, 2012

Cannot create diagram in SQL 2005

i get the following 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 the db owner but still wouldnt let me install and create diagrams.

help!

cheers

I moved this thread from SSIS forum...I hope you can get better luck here...|||

hey i found the answer

you gotta set the owner to sa and then go to the database properties, then options, then change compatibility fromn sql 2000 (80) to sql 2005 (90)

too easy..

thanks buddy

No comments:

Post a Comment