问题描述
我使用高级服务安装了SQL Server 2008 Express，但是当我尝试创建新数据库时，全文索引选项变灰，我认为已经安装了全文索引，因为我做了一个查询如下：
pre $ 使用[mydbname]
选择fulltextserviceproperty（'isfulltextinstalled'）
此查询返回1，因此我认为它已成功安装。
使用已安装的高级服务版本的MSSQL Express支持全文索引。页面供参考：
确保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!
这篇关于为什么全文索引选项灰显？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！