DB diagram in sql server

[seema.nare@oasis-bs.com]

How can i create the database diagram in MS SQL server management studio version 9.0
I don't want to use SQL server 2000 enterprise manager,as i don't have the licensed copy of it.

Any soln?

 

[TechGnome]

You can't. Plain and simple. The only database that SQLSMS can create diagrams for are SQL2005 databases. I spend an evening with SQL 2005 on this issue a few weeks ago. It wouldn't let me create a diagram (I had atached a SQL2000 DB) until I dropped the DB and recreated it as a 2005 database....

-tg

 

[seema.nare@oasis-bs.com]

My DB is created in 2005 only. Still it does not allow me to do so.

 

[seema.nare@oasis-bs.com]

In addition to the above:
Is it connected with the compatibility lavel of the DB?
(70 : Sql server 7.0
80:Sql server 2000
90: Sql server 2005.)
I tried to change it for my DB (which is 80 by default ) using
EXEC sp_dbcmptlevel 'Test', '90';
But I got the foll error
"Valid values of database compatibility level are 60, 65, 70, or 80."

Plz help.