使用高级服务表达不能创建全文索引

问题描述

我安装了SQL Server 2012 Express Edition高级服务，其中声明它包含全文索引。这里有一个链接指出：

我已确认全文服务正在运行，但是当我尝试创建一个全文目录，但它失败。 （Microsoft.SqlServer.Smo）

任何人有任何想法？

解决方案

你无法通过向导来做到这一点，因为存在一些bug。即使我选择不跟踪更改并在完成时不填充索引，我仍然收到有关SQL Agent的错误消息：

尽管存在错误，但我仍能继续，但在更远处我终于收到了你所犯的错误。不过，我在DDL中执行以下操作时没有任何问题：

  CREATE TABLE dbo.x 
（
x NVARCHAR （255）NOT NULL CONSTRAINT uq_x UNIQUE（x）
）; 
 GO 
创建全文目录x_catalog; 
 GO 
 CREATE FULLTEXT INDEX 
 ON dbo.x（x语言1033）
 KEY索引uq_x ON x_catalog; 
 GO 
  

这表明Express确实支持Full-Text，它只是UI有点困惑。我怀疑它不知道如何判断你实际运行的Express版本。

所以在短期内，我会推荐使用DDL而不是UI。实际上，由于用户界面似乎只是在创建目录时出错，因此如果您首先通过DDL创建目录，则可以使用UI创建索引...

  CREATE FULLTEXT CATALOG x_catalog; 
  

...然后在单步执行向导时选择该目录，而不是创建一个新目录。当然，你也必须忽略关于SQL Server Agent的异常，但它不会停止向导，你可以点击OK并忽略它。

我向管理工作室提交了一个Connect项目，请投票支持它，并希望这会得到解决：

SQLServer / feedback / details / 740181 / management-studio-does-not-full-manage-full-text-in-sql-server-expressrel =noreferrer> http://connect.microsoft.com/SQLServer/ feedback / details / 740181 / management-studio-does-not-full-manage-full-text-in-sql-server-express

I have installed SQL Server 2012 Express Edition Advanced Services which states that it includes Full-text indexing. Here is a link that states this:

http://msdn.microsoft.com/en-us/library/cc645993.aspx

I have confirmed that Full-text service is running, however when I try to create a full-text catalog, it fails. I get the message "Full-text is not supported on this edition of SQL Server. (Microsoft.SqlServer.Smo)"

Anyone have any ideas?

解决方案

You can't do this through the wizard, because there are a couple of bugs. Even if I chose not to track changes and not to populate the index when it was finished, I still got an error about SQL Agent:

In spite of the error, I was able to proceed, but at a further step I finally did receive the error you did. However I had no problem doing the following in DDL:

CREATE TABLE dbo.x
(
  x NVARCHAR(255) NOT NULL CONSTRAINT uq_x UNIQUE(x)
);
GO
CREATE FULLTEXT CATALOG x_catalog;
GO
CREATE FULLTEXT INDEX
  ON dbo.x(x LANGUAGE 1033)
  KEY INDEX uq_x ON x_catalog;
GO

This shows that Express certainly does support Full-Text, it's just the UI that is a little confused. I suspect it doesn't know how to tell which version of Express you actually have running.

So in the short term I would recommend using DDL instead of the UI. In fact, since the UI only seems to trip on creating the catalog, you can use the UI to create the indexes if you first create the catalog via DDL...

CREATE FULLTEXT CATALOG x_catalog;

...and then pick that catalog when stepping through the wizard, instead of creating a new one. Of course you'll also have to ignore the exception regarding SQL Server Agent, but it does not stop the wizard, you can just click OK and ignore it.

I've filed a Connect item against Management Studio, please vote for it and hopefully this will be corrected:

http://connect.microsoft.com/SQLServer/feedback/details/740181/management-studio-does-not-fully-manage-full-text-in-sql-server-express

这篇关于使用高级服务表达不能创建全文索引的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！