为什么全文索引选项灰显？ [英] Why the Full-Text indexing option is greyed out?

问题描述

我使用高级服务安装了SQL Server 2008 Express，但是当我尝试创建新数据库时，全文索引选项变灰，我认为已经安装了全文索引，因为我做了一个查询如下：



pre $ 使用[mydbname]
选择fulltextserviceproperty（'isfulltextinstalled'）


此查询返回1，因此我认为它已成功安装。

使用已安装的高级服务版本的MSSQL Express支持全文索引。页面供参考：

http://www.microsoft.com/downloads/details.aspx?familyid=B5D1B8C3-FDA5-4508-B0D0-1311D670E336&displaylang=en

解决方案

确保NAMED PIPES在配置管理器中的协议中启用，因为全文服务需要它！

I installed SQL Server 2008 Express with Advanced Services, but when I try to create a new database, the option Full-Text indexing is greyed out, I believe the full-text indexing has been installed, because I did a query as below:

use [mydbname]
select fulltextserviceproperty('isfulltextinstalled') 

This query returns 1, so I think it has been successfully installed.

Full-text indexing is supported in MSSQL Express with Advanced Services edition, which I have installed. Page for reference:
http://www.microsoft.com/downloads/details.aspx?familyid=B5D1B8C3-FDA5-4508-B0D0-1311D670E336&displaylang=en

解决方案

Make sure NAMED PIPES is enabled in the protocols in configuration manager as full text service needs this!

这篇关于为什么全文索引选项灰显？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！