Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in SQL by (20.3k points)

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:

What's wrong here?

1 Answer

0 votes
by (40.7k points)

It is commonly considered as an error due to using the wrong version of SSMS i.e. SQL Server Management Studio. Try using the version which is designed for your database version. 

You can also use the command select @@version to check which version of SQL server you are actually using. 

This version will be reported in such a way that it'll be easier to interpret than that shown in the Help About in SSMS.

Related questions

0 votes
1 answer
0 votes
1 answer
0 votes
1 answer
asked Dec 9, 2020 in SQL by Appu (6.1k points)

Browse Categories

...