Doug Hughes is a veteran programmer who
founded Alagad after briefly flirting with a career in computer animation.
Doug has a strong record of achievement with large, complex web applications.
His ability to learn and apply new technologies and techniques has helped Doug become one of the web application
development industry’s most highly regarded experts.
Doug’s current focus at Alagad is leading an application development team dedicated to helping organizations improve operational efficiency and performance. This commitment to client success has helped Alagad achieve record growth. A frequent speaker at industry conferences and user groups, Doug also regularly contributes to several well-known open source projects. In addition, his articles have been featured in numerous technical publications.
- 85 entries Alagad
- 12 entries Ant
- 167 entries ColdFusion
- 11 entries ColdSpring
- 20 entries Conferences and Events
- 1 entries Development Tools
- 5 entries Dynamic Programming
- 1 entries Flexmaniacs
- 52 entries General
- 4 entries Groovy
- 5 entries JRun
- 17 entries Jobs
- 17 entries Model-Glue
- 27 entries OO Development
- 53 entries Programming
- 31 entries Reactor For ColdFusion
- 13 entries SQL
- 14 entries The Server Side
- 7 entries Validat
- 8 entries Farcry CMS
- 32 entries Flex
- 10 entries Flex
- 3 entries Hibernate
- 3 entries jQuery
- 1 entries Presentations
- 1 entries Press
Subscribe to our The Alagad Technical Team Blog
Can't Create Diagrams in SQL Server 2005?
This issue has plagued me since moving to SQL Server 2005. I find the diagram tools help me visualize my data and relationships. The problem is that with SQL 2005 sometimes you get this error when you try to create a new diagram:
You can follow the instructions in the error message till the cows come home and still not be able to successfully create a diagram. This is true even if you set the owner to SA or some other administrator.
After much screaming and gnashing of teeth I finally learned that the problem isn't really with the owner, it's with the database compatibility level. Your database may be running in either SQL 7 or 2000 compatibility mode, not 2005.
To resolve the problem, in SQL Server Management Studio, right click on the database node and click Properties. Select Options on the left and set the compatibility level to SQL Server 2005 (90).
Just make that change, click OK and you're good to go.
17 responses to “Can't Create Diagrams in SQL Server 2005?”
thanks a lot..I struggled a lot with this error.nice solution
Thanks a lot..struggled a lot with this error.Nice solution
vaya puta mierda!
This is verrryyyyy goood solution
Thanque veryyyyyy much
thank you
Goodday every One,
I have problem with sql 2005 and 2000 together,to great Database Diagrams. How?
Now ? tell you how.
I have two sql server in my machin, one of them is sql 2000 woking for Program "LOGO GO" and second server for me(I am studing in Course software Microsoft). My sql version 2005 and there ? cannt dowload upgrate anything(my friends say, due to sql 2000 server)
and ? have sql2005(80), but havnt sql 2005(90). So what ? must to do , to break this problem.
I will wait your reply
Thank you Very much....
I have the problem that this guid should fix, but in the database property option it is alredy sql 2005(90)??
Since writing this entry in February I also found this script somewhere on the web that has worked for me in every case:
EXEC sp_dbcmptlevel 'YourDatabase', '90';
go
ALTER AUTHORIZATION ON DATABASE::YourDatabase TO "sa"
go
use YourDatabase
go
EXECUTE AS USER = N'dbo' REVERT
go
Weee, thanks Doug Hughes, your solution worked.
Great... your solution worked perfectly... thanks...
thanks...
Thanks, Doug. Worked like a charm! :-)
Very useful Doug. Many thanks.
Very useful my friend. Thanks.
Very good.
I tried the above mentioned solution but my db's compatibility level is already at 90... I used the script as well but it doesn't work. I'm the owner of the db but still it throws the same error. Plzzzzz if anyone could help!
Leave a Reply
Very good to know. We have a 2000 and 2005 server at work, and I have yet to develop any apps fresh on the 2005 environment. This will save me the gnashing of teeth. :-)
Posted By: Joshua Curtiss on Feb 27, 2008 at 12:00 AM