Recently, I was working on one of the databases and I tried to insert a table through SQL Server Management Studio (SSMS) and I came across the following error.
Error:
The backend version is not supported to design database diagrams or tables.
Reproduce Error:
Let me reproduce this error step by step.
Step 1:
Let’s create a new database namely ‘TestDB’ as shown below.
CREATE DATABASE TestDB; GO
Step 2:
Now, lets expand the database TestDB, then right click on the Tables option and then select New and then select Table… as shown below.
Step 3:
This will display the following error.
Solution:
This error occurs when you have the older version (18) of SSMS installed on your device. To check the version installed on your device, navigate to the Help menu and click on About menu in the menu bar as shown below.
A new window will pop up with all the version details of the SSMS.
In order to solve this error, you need to install a new version (19 or higher) of SQL Server Management Studio (SSMS). You can download it from here
Conclusion:
Make sure you have updated version of SSMS all the time to avoid such errors.
SQL Server Portal 