[Solved] The Backend version is not supported to design database digrams or tables.

by

I Came across this error when I got to work on some other machine with SQL Server Management Studio 2008 R2 installed.

This error is thrown up when I tried to modify the design of a table by right-clicking on a table and selecting the “Design” option.

Error- Backend Version Not Supported - SQL Server Management Studio
Error- Backend Version Not Supported – SQL Server Management Studio

Solution:

  • Check Database version using “SELECT @@VERSION”select-versionIn my case it was SQL Server 2012 SP1.
  • Update the SQL Server Management Studio to the version of the SQL Server.

That’s all!

Leave a Comment