SQL 全文搜索安装与否
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/6511167/
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
Full text search installed or not
提问by DotnetSparrow
I have instaled SQL server 2008 R2 and when I run this SQL in SQL server management studio:
我已经安装了 SQL server 2008 R2，当我在 SQL server management studio 中运行此 SQL 时：
SELECT FULLTEXTSERVICEPROPERTY('IsFullTextInstalled')
I get 0
我得到 0
But If I run this:
但是如果我运行这个：
SELECT * FROM sys.fulltext_catalogs
I get one row. I want to know If fulltext search is installed on my sql server or do I need to reinstall SQL server with advance options.
我得到一排。我想知道我的 sql server 上是否安装了全文搜索，或者我是否需要使用高级选项重新安装 SQL server。
Please suggest.
请建议。
回答by RThomas
My answer:
我的答案：
If FULLTEXTSERVICEPROPERTY says it's not installed, then I would install from the original media. Run through the installer and simply add Full Text Search from the features page.
如果 FULLTEXTSERVICEPROPERTY 说它没有安装，那么我会从原始媒体安装。运行安装程序，只需从功能页面添加全文搜索。
FTS is fully in the SQL Engine in 2008so if it thinks it isn't installed, then ya best make it happy.
FTS完全在 2008 年的 SQL 引擎中，所以如果它认为它没有安装，那么你最好让它开心。
My opinions/ponderings:
我的意见/思考：
Did you move a database from a previous SQL installation that had full text installed? That might explain the row in sys.fulltext_catalogs.
您是否从以前安装了全文的 SQL 安装中移动了数据库？这可能解释了 sys.fulltext_catalogs 中的行。
When you open a Database in SSMS, under the Storage Folder, Full Text Catalog folder do you have the option to add a New Catalog when you right click?
当您在 SSMS 中打开数据库时，在存储文件夹、全文目录文件夹下，您是否可以选择在右键单击时添加新目录？
In SQL Configuration Manager do you see the Full Text Daemon Launcher service?
在 SQL 配置管理器中，您是否看到全文守护程序启动器服务？
回答by GGES
I just made the test on a new SQL Server 2016 Express installation withoutfulltext feature (did not used the "Advanced Services" setup).
我刚刚在没有全文功能的新 SQL Server 2016 Express 安装上进行了测试（没有使用“高级服务”设置）。
I can confirm you can perfectly create fulltext catalogs on databases even if fulltext feature is not intalled.
我可以确认，即使未安装全文功能，您也可以在数据库上完美地创建全文目录。
But if you try to create a fulltext index, you'll get a clear error message stating the feature is missing :
但是，如果您尝试创建全文索引，则会收到一条明确的错误消息，指出缺少该功能：
Executing :
执行：
CREATE FULLTEXT INDEX ON dbo.tbltxt(coltext)
KEY INDEX ui_tbltxt
WITH STOPLIST = SYSTEM;
GO
...will throws error :
...会抛出错误：
Msg 7609, Level 17, State 5, Line 87 Full-Text Search is not installed, or a full-text component cannot be loaded.
消息 7609，级别 17，状态 5，第 87 行全文搜索未安装，或无法加载全文组件。
回答by bereket gebredingle
Easy way
简单的方法
SELECT
CASE FULLTEXTSERVICEPROPERTY('IsFullTextInstalled')
WHEN 1 THEN 'Full-Text installed.'
ELSE 'Full-Text is NOT installed.'
END;
inspired by https://www.sqlshack.com/hands-full-text-search-sql-server/
灵感来自https://www.sqlshack.com/hands-full-text-search-sql-server/
