This backend version is not supported to design database diagrams or tables error in sql server 2008

In this post we will discuss how to resolve the error "this backend version is not supported to design database diagrams" which comes in sql server 2008.

Also you can check out:

- ModalPopupExtender background css not coming when showing from code behind in asp.net

- ModalPopupExtender example in Ajax in Asp.Net

- Reset auto increment sql server 2008 - Reset Table Identity Sql Server 2008

Recently I got this error as "this backend version is not supported to design database diagrams" which comes in SQL Server 2008.

I opened SQL Server 2012 database in SQL Server 2008 R2. Then I got the error.

Solution-1:
One very easy solution is to install SQL Server 2012.

Solution-2:
The second solution is install SP2 for  SQL Server 2008 R2. This solution work for me.