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

sql sql-server database ssms
JensOlsen picture JensOlsen · Aug 5, 2014 · Viewed 193.9k times · Source

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

Gary Walker picture Gary Walker · Aug 5, 2014

This is commonly reported as an error due to using the wrong version of SSMS(Sql Server Management Studio). 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. This version is reported in a way that is easier to interpret than that shown in the Help About in SSMS.

Using a newer version of SSMS than your database is generally error-free, i.e. backward compatible.

Related questions

How to switch database context to newly created database?

I wrote a script to create a database: 1: USE master; 2: IF (db_id('myDB') is null) 3: CREATE DATABASE myDB; 4: USE myDB; but it does not work... I got an error: Could not locate entry in sysdatabases for database 'myDB'. No …

Read More
Reset identity seed after deleting records in SQL Server

I have inserted records into a SQL Server database table. The table had a primary key defined and the auto increment identity seed is set to “Yes”. This is done primarily because in SQL Azure, each table has to have …

Read More
How do I list all the columns in a table?

For the various popular database systems, how do you list all the columns in a table?

Read More