是否安装全文搜索 [英] Full text search installed or not

问题描述

我已安装 SQL Server 2008 R2，当我在 SQL Server Management Studio 中运行此 SQL 时:

I have instaled SQL server 2008 R2 and when I run this SQL in SQL server management studio:

SELECT FULLTEXTSERVICEPROPERTY('IsFullTextInstalled')

我得到 0

但是如果我运行这个:

SELECT * FROM sys.fulltext_catalogs

我得到一排.我想知道我的 sql server 上是否安装了全文搜索，还是需要使用高级选项重新安装 SQL server.

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.

请提出建议.

推荐答案

我的回答:

如果 FULLTEXTSERVICEPROPERTY 说它没有安装，那么我会从原始媒体安装.运行安装程序，只需从功能页面添加全文搜索.

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.

FTS 2008 年完全在 SQL 引擎中 所以如果它认为它没有安装，那么你最好让它开心.

FTS is fully in the SQL Engine in 2008 so if it thinks it isn't installed, then ya best make it happy.

我的意见/思考:

您是否从以前安装了全文的 SQL 安装中移动了数据库?这可能解释了 sys.fulltext_catalogs 中的行.

Did you move a database from a previous SQL installation that had full text installed? That might explain the row in sys.fulltext_catalogs.

当您在 SSMS 中打开数据库时，在 Storage Folder、Full Text Catalog 文件夹下，您是否可以在右键单击时选择添加新目录?

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?

在 SQL 配置管理器中，您是否看到全文守护程序启动器服务?

In SQL Configuration Manager do you see the Full Text Daemon Launcher service?

这篇关于是否安装全文搜索的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！