There is no menu choice to create a new database diagram

[DangerDev]

Hi,
I want to create a DataBase Diagram using MS SQL Server Management Studio 2005.
But on context menu of DataBase Diagrams Folder, I am not able to see "New Database Diagram" menu item for any of the Database.
I am getting only two menu item "Working with Sql server 2000 Diagrams" and "Refresh".

Please post suggestions and answers.
Thanks in advance.

[hspc]

Are you connecting to a "SQL Server 2000" server? Management studio 2005 cannot create database diagrams on SQL Server 2000 servers.

[DangerDev]

Nop,
its not showing menu item itself, its not showing menu item for any of the database(even system database Northwind.

[hspc]

Northwind is not a system database. Anyway, I'm talking about the server version that you connect to.
You can check it by right clicking the server node and clock properties, check the version.
or :
Select @@version

[DangerDev]

ya you are Right, its showing 2000,
but in my system both MS SQL Server 2000 and MS SQL Server 2005 is installed and i am using MS SQL Server Management Studio 2005. How can i connect to 2005 data base because when i am connecting its showing only one data base engin.
any way thanx for your help at least i got the problem.

if you can suggest more please do so, i'll be thankful.

[hspc]

To add a new server to the object explorer click the "Connect object explorer" icon, or open "file ->Connect object explorer...". Enter server connection information and it will be added.

[DangerDev]

Thanx, For all your help.
Problem has been solved.
My MS SQL server version is 2000. Hence it will generate the Data Base diagram using SQL Server Enterprize manager. :)