[Solved] The Backend version is not supported to design databas disgrams or tables.1 min read

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

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

Error- Backend Version Not Supported - SQL Server Management Studio

Solution:

  • Check Database version using “SELECT @@VERSION”

    select-version

    In 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

%d bloggers like this: