是否安装了全文搜索

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.

请建议。

1 个解决方案

#1

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 2008 so 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配置管理器中，您是否看到了全文守护程序启动器服务？