如何启用Full Text Search in SQL Server 2014
。
我已经在网上搜索了几个小时,一些关于SQL Server 2012的帖子说它在安装过程中的功能中,但我去了那里,我没有选项来启用它。我确定它确实已安装但未启用,运行以下查询:
SELECT SERVERPROPERTY('IsFullTextInstalled') AS IsFullTextInstalled,
DatabaseProperty(DB_NAME(DB_ID()), 'IsFulltextEnabled') AS IsFulltextEnabled
返回:
IsFullTextInstalled=1
IsFullTextEnabled=0
谢谢!
发布于 2018-02-20 16:54:15
你已经完成了实例的“安装”部分。我认为“启用”与为实例中的特定数据库建立全文搜索有关,例如,使用T-SQL和AdventureWorks:
--create a full-text catalog
USE AdventureWorks;
GO
CREATE FULLTEXT CATALOG AdvWksDocFTCat;
-- Ensure the table (Document in this example) has a unique, single-column, non-nullable index
CREATE UNIQUE INDEX ui_ukDoc ON Production.Document(DocumentID);
-- Create a full-text index on the Document table
CREATE FULLTEXT INDEX ON Production.Document
(
Document --Full-text index column name
TYPE COLUMN FileExtension --Name of column that contains file type information
Language 2057 --2057 is the LCID for British English
)
KEY INDEX ui_ukDoc ON AdvWksDocFTCat --Unique index
WITH CHANGE_TRACKING AUTO --Population type;
GO
有关此示例的更多详细信息,请参阅微软文章:https://docs.microsoft.com/en-us/sql/relational-databases/search/get-started-with-full-text-search
更通用的教程请访问:https://docs.microsoft.com/en-us/sql/relational-databases/search/create-and-manage-full-text-indexes
https://stackoverflow.com/questions/47442654
复制