Express with Advanced Services，无法创建全文索引 [英] Express with Advanced Services, can't create Full Text Index

问题描述

我安装了 SQL Server 2012 Express Edition Advanced Services，其中声明它包含全文索引.这是一个说明这一点的链接:

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

我已经确认全文服务正在运行，但是当我尝试创建全文目录时，它失败了.我收到消息此版本的 SQL Server 不支持全文.(Microsoft.SqlServer.Smo)"

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)"

有人有什么想法吗?

推荐答案

您无法通过向导执行此操作，因为存在一些错误.即使我选择不跟踪更改并且在完成时不填充索引，我仍然收到有关 SQL 代理的错误:

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:

无法加载选择或创建人口计划"全文向导形式.
此版本的 SQL Server 不支持 SQL Server 代理.(Microsoft.SqlServer.Smo)

Cannot load 'Select or Create Population Schedules' Full-Text Wizard form.
SQL Server Agent is not supported on this edition of SQL Server. (Microsoft.SqlServer.Smo)

尽管出现错误，我还是能够继续，但在进一步的步骤中，我终于收到了您所做的错误.但是我在 DDL 中执行以下操作没有问题:

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

这说明 Express 确实支持全文，只是 UI 有点混乱.我怀疑它不知道如何判断您实际运行的是哪个版本的 Express.

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.

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

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;

...然后在逐步执行向导时选择该目录，而不是创建一个新目录.当然，您也必须忽略有关 SQL Server Agent 的异常，但它不会停止向导，您只需单击确定"并忽略它即可.

...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.

我已针对 Management Studio 提交了一个 Connect 项目，请投赞成票，希望这会得到纠正:

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

• Management Studio 不完全管理 SQL Server Express 中的全文

我不知道该项目是否已得到解决，或者是否已转移到新的反馈系统中.我开始搜索但很好运气.

I don't know if that item has been addressed or if it made it over to the new feedback system. I started to search for it but good luck.

这篇关于Express with Advanced Services，无法创建全文索引的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！