如何在SQL Server 2005 Express中启用全文索引？ [英] How to enable Full-text Indexing in SQL Server 2005 Express?

问题描述

我试图在SQL Server 2005 Express中启用全文索引。我在我的笔记本电脑上运行Vista Ultimate。

据我所知，标准版本的SQL Server Express没有全文索引。我已经下载并安装了Microsoft SQL Server 2005 Express Edition with Advanced Services Service Pack 2（

我也选择了Use full-文本索引。在数据库属性>文件区域。

我可以运行sql查询SELECT fulltextserviceproperty（'IsFulltextInstalled'）;并返回1。

我遇到的问题是，当我在设计视图中打开表格并选择管理全文索引时;全文索引窗口显示消息...

创建全文索引不可用，请检查您是否有

关于要检查什么或下一步要去的任何想法？

p>

解决方案

  sp_fulltext_database'enable'
 
 CREATE FULLTEXT CATALOG [myFullText] 
 WITH ACCENT_SENSITIVITY = ON 
 
 CREATE FULLTEXT INDEX ON [dbo]。[tblName] KEY INDEX [PK_something] ON [myFullText] WITH CHANGE_TRACKING AUTO 
 ALTER FULLTEXT INDEX ON [dbo] 。[otherTable] ADD（[Text]）
 ALTER FULLTEXT INDEX ON [dbo]。[teyOtherTable] ENABLE 
  

I am trying to enable Full-text indexing in SQL Server 2005 Express. I am running this on my laptop with Vista Ultimate.

I understand that the standard version of SQL Server Express does not have full-text indexing. I have already downloaded and installed "Microsoft SQL Server 2005 Express Edition with Advanced Services Service Pack 2" (download).

I have also ensured that both the "SQL Server (instance)" and "SQL Server FullText Search (instance)" services are running on the same account which is "Network Service".

I have also selected the option to "Use full-text indexing" in the Database Properties > Files area.

I can run the sql query "SELECT fulltextserviceproperty('IsFulltextInstalled');" and return 1.

The problem I am having is that when I have my table open in design view and select "Manage FullText Index"; the full-text index window displays the message...

"Creation of the full-text index is not available. Check that you have the correct permissions or that full-text catalogs are defined."

Any ideas on what to check or where to go next?

解决方案

sp_fulltext_database 'enable'

CREATE FULLTEXT CATALOG [myFullText]
WITH ACCENT_SENSITIVITY = ON

CREATE FULLTEXT INDEX ON [dbo].[tblName] KEY INDEX [PK_something] ON [myFullText] WITH CHANGE_TRACKING AUTO
ALTER FULLTEXT INDEX ON [dbo].[otherTable] ADD ([Text])
ALTER FULLTEXT INDEX ON [dbo].[teyOtherTable] ENABLE

这篇关于如何在SQL Server 2005 Express中启用全文索引？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！