Data Diagrams

I hav restored sql server7 DB in sql server 2005 exp.....but the data diag. donot open...what 2 do

Database Diagrams are different between 7 and 2005. You will need to change the "compatibility level" of the database (use the Properties tab of the database in Management Studio) and set it to 9.0 instead of 7.0, then recreate the database diagrams.

Buck Woody

Data Diagrams

I hav restored sql server7 DB in sql server 2005 exp.....but the data diag. donot open...what 2 do

Database Diagrams are different between 7 and 2005. You will need to change the "compatibility level" of the database (use the Properties tab of the database in Management Studio) and set it to 9.0 instead of 7.0, then recreate the database diagrams.

Buck Woody