不支持设计数据库图表或表的后端版本 [英] The backend version is not supported to design database diagrams or tables
问题描述
我正在尝试通过SQL Server Management Studio向我新创建的数据库添加表。
但是,我遇到错误:
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
要查看我当前安装的版本,我在SSMS中点击了,这就是:
To see my currently installed versions I clicked about in SSMS and this is what came up:
>
这里有什么问题?
推荐答案
这通常被报告为由于使用错误版本的SMSS而导致的错误。使用为您的数据库版本设计的版本。您可以使用命令 select @@ version
来检查您实际使用的sql服务器的版本。
This is commonly reported as an error due to using the wrong version of SMSS. 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 than shown in the Help About in SMSS.
使用较新版本的SMSS比您的数据库通常没有错误,即向后兼容。
Using a newer version of SMSS than your database is generally error free, i.e. backward compatible.
这篇关于不支持设计数据库图表或表的后端版本的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!