SQL 不支持后端版本设计数据库图表或表格
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/25146474/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
The backend version is not supported to design database diagrams or tables
提问by JensOlsen
I'm trying to add a table to my newly created database through SQL Server Management Studio. However I get the error:
我正在尝试通过 SQL Server Management Studio 向我新创建的数据库添加一个表。但是我收到错误：
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:
要查看我当前安装的版本，我在 SSMS 中单击了有关内容，结果如下：
What's wrong here?
这里有什么问题？
回答by Gary Walker
This is commonly reported as an error due to using the wrong version of SSMS(Sql Server Management Studio). Use the version designed for your database version. You can use the command select @@versionto check which version of sql server you are actually using. This version is reported in a way that is easier to interpret than that shown in the Help About in SSMS.
由于使用了错误版本的 SSMS（Sql Server Management Studio），这通常被报告为错误。使用为您的数据库版本设计的版本。您可以使用该命令select @@version来检查您实际使用的是哪个版本的 sql server。此版本的报告方式比 SSMS 中的“关于帮助”中显示的方式更易于解释。
Using a newer version of SSMS than your database is generally error-free, i.e. backward compatible.
使用比数据库更新版本的 SSMS 通常不会出错，即向后兼容。
回答by MikeSNP
I ran into this problem when SQL Server 2014 standard was installed on a server where SQL Server Express was also installed. I had opened SSMS from a desktop shortcut, not realizing right away that it was SSMS for SQL Server Express, not for 2014. SSMS for Express returned the error, but SQL Server 2014 did not.
在安装了 SQL Server Express 的服务器上安装了 SQL Server 2014 标准时，我遇到了这个问题。我从桌面快捷方式打开了 SSMS，并没有立即意识到它是 SQL Server Express 的 SSMS，而不是 2014 年的 SSMS。Express 的 SSMS 返回了错误，但 SQL Server 2014 没有。
回答by Muarucha
I was having the same problem, although I solved out by creating the table using a script query instead of doing it graphically. See the snipped below:
我遇到了同样的问题，尽管我通过使用脚本查询而不是图形方式创建表来解决。请参阅下面的剪辑：
USE [Database_Name]
GO
CREATE TABLE [dbo].[Table_Name](
[tableID] [int] IDENTITY(1,1) NOT NULL,
[column_2] [datatype] NOT NULL,
[column_3] [datatype] NOT NULL,
CONSTRAINT [PK_Table_Name] PRIMARY KEY CLUSTERED
(
[tableID] ASC
)
)
回答by Alison Coughtrie
You only get that message if you try to use Designer or diagrams. If you use t-SQL it works fine:
如果您尝试使用 Designer 或图表，您只会收到该消息。如果您使用 t-SQL 它工作正常：
Select *
into newdb.dbo.newtable
from olddb.dbo.yourtable
where olddb.dbo.yourtablehas been created in 2008 exactly as you want the table to be in 2012
whereolddb.dbo.yourtable已在 2008 年完全按照您希望的表在 2012 年创建
