DataBase Diagram diabled SQL 2005

• Gautam Kaushal

  Newbie

  Points: 2

  More actions

  December 28, 2006 at 10:37 am

  #61741

  Hi,

  I've been assigned to work on a computer terminal where a SQL Server 2005 is already installed. I've created couple of Tables and i wanted to generate DataBase Diagrams of them. But when i go to DatabaseDiagrams tab under ObjectExplorer in Microsoft SQL Server Management Studio 2005, i don't see any option to create new diagrams on right-clicking DatabaseDiagrams. Even enabling the the DatabaseDiagrams tab from the Toolbars shows all the menu items pertaining to this functionality as disabled.

  I was hoping if someone would have any idea about this issue.

  Regards,

  Gautam

• Rich Hansell

  SSCrazy

  Points: 2346

  More actions

  December 28, 2006 at 11:09 am

  #680326

  If you are trying to diagram SQL 2000 DBs you need to use Enterprise manager.. SSMS cannot work with SQL 2000 diagrams..

  Rich

• Gautam Kaushal

  Newbie

  Points: 2

  More actions

  December 29, 2006 at 7:11 am

  #680476

  Thanks for the input Rich, I appreciate it.

  Gautam