如何在 SQL Server 2008 上安装全文搜索
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/3173446/
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
How to install FullText Search on SQL Server 2008
提问by Jordon Willis
Possible Duplicate:
How to install fulltext on sql server 2008?
I have recently installed SQL Server 2008 R2
我最近安装了 SQL Server 2008 R2
When I tried to create Full Text Search Index
当我尝试创建全文搜索索引时
Example
例子
CREATE FULLTEXT INDEX ON DATABASENAME.dbo.MYTABLE
(
column_to_index
Language 0X0
)
KEY INDEX myindex ON DATABASENAMECatalog
WITH CHANGE_TRACKING AUTO
It had given me following error:
它给了我以下错误：
Msg 7609, Level 17, State 5, Line 4 Full-Text Search is not installed, or a full-text component cannot be loaded.
消息 7609，级别 17，状态 5，第 4 行全文搜索未安装，或无法加载全文组件。
I tried following
我试过
1: Right Click on My Computer and Click "Manage"
1：右键单击“我的电脑”，然后单击“管理”
2: Double Click "Services and Applications"
2：双击“服务和应用程序”
3: Double Click "SQL Server Configuration Manager"
3：双击“SQL Server配置管理器”
But I can't able to perform following 2 steps, as their is No FULL TEXT SEARCH service was their.
但我无法执行以下 2 个步骤，因为他们没有全文搜索服务。
4: Double Click "SQL Server Services"
4：双击“SQL Server服务”
5: Check if "SQL Server Full Text Search" is not started, than Right Click and Press on Start.
5：检查“SQL Server全文搜索”是否未启动，然后右键单击并按“开始”。
Can anyone please guide me how to install full text search on SQL Server 2008
任何人都可以指导我如何在 SQL Server 2008 上安装全文搜索
回答by John Sansom
The simplest way to validate whether or not you have installed the Full Text "component" of SQL Server 2008 is to execute the following T-SQL
验证是否已安装 SQL Server 2008 的全文“组件”的最简单方法是执行以下 T-SQL
select SERVERPROPERTY('IsFullTextInstalled')
If this query returns a value of '1' then the component is installed.
如果此查询返回值“1”，则组件已安装。
For further readining on how to get started see: Getting Started with Full-Text Search
有关如何开始的进一步阅读，请参阅：全文搜索入门
回答by 8kb
As the comments suggested, you should probably re-install and make sure you choose the Full-Text Search option (directly under SQL Server Replication).
正如评论所建议的那样，您可能应该重新安装并确保选择全文搜索选项（直接在 SQL Server 复制下）。
(source: free.fr)
（来源：free.fr）
FYI, this image comes from a step by step install guide
仅供参考，此图像来自分步安装指南
