December 7, 2005 at 4:14 pm
I tried to create a new database diagrams in SQL 2005 according to the document. However, when I right click the Database Diagrams node in Object Explorer pane od Management Studio, I only see 'Workng with SQL 2000 diagrams'. I chose it, but nothing happen ?
Is this a bug or I configured my SQL 2005 inappropriately.
George
December 8, 2005 at 4:48 am
Have similar problem on my PC. but think this may be related to the additional problem I have - any Database I create in SQL 2005, only allows me to set the Compatibility level to SQl 7.0 or SQL 2000. The PC still has SQL 2000 installed in addition to SQL 2005.
But I don't know if both versions are allowed to co-exist or if SQL 2005 can be fixed to raise its Compatibility level! Any clues, anybody?
John.
December 9, 2005 at 9:08 am
Are you sure the server is 2005, and you're not using SSMS to connect to it?
Sometimes people do a side by side installation without realising it!
December 11, 2005 at 5:43 am
I was using SSMS, but it seemed as if SSMS was stuck in SQL 2000 mode!
I've now removed SQL 2000 from the PC, reinstalled SQL 2005 and Database Diagrams are now available.
December 11, 2005 at 5:43 am
I was using SSMS, but it seemed as if SSMS was stuck in SQL 2000 mode!
I've now removed SQL 2000 from the PC, reinstalled SQL 2005 and Database Diagrams are now available.
May 30, 2006 at 9:46 am
I am sure that you already know this, but you might try changing the Compatibility Level of the Database from 90(Default in SQL Server 2005) to 80. You can do this by right-clicking on the database -> OPTIONS -> Compatibility Level. Once you change it to 80, then you can install the Database Diagram support objects by clicking on the Database Diagrams folder located within the database you are working on. Once complete you can change the Compatibility Level back to 90 and still have the Database Diagrams working on the requested database.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply