JensOlsen JensOlsen - 4 years ago 975
SQL Question

The backend version is not supported to design database diagrams or tables

I'm trying to add a table to my newly created database through SQL Server Management Studio.
However I get the error:


the backend version is not supported to design database diagrams or tables


To see my currently installed versions I clicked about in SSMS and this is what came up:

enter image description here

What's wrong here?

Answer Source

This is commonly reported as an error due to using the wrong version of SMSS. Use the version designed for your database version. You can use the command select @@version to check which version of sql server you are actually using.

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download