Tuesday, March 20, 2012

problem with Server Management Studio Express and diagrames

so I have had a database in Sql Server 2000, in my DB i have made database diagrams.

now I have installed on other PC(where does't install sql 2000) Sql Server Management Studio Express where I have opened my db , bat db diagrams does't work.

what can I do? how can I solve this problem?

enyone can explain me?

thanks.

Management Studio can't open SQL 2000 diagrams, if you click on the diagrams branch of the tree it should ask if you want to install diagram support, once this is done you can create new diagrams.|||ok, bat when I opend diagrams branch of the tree, it doesn't ask if I want or not to install diagram|||

hi,

usually you have to first import the database to the new SQL Server 2005 instance (as you already did)..

then modify the compatibility level to 90 via the SSMSE, database properties (options tab), and finally set the database owner to a valid principal, again SSMSE, database properties (files tab, "owner" peroperty )...

then you should be able to access database diagrams..

regards

No comments:

Post a Comment