如何在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。 我遇到的问题是,当我在设计视图中打开表格并选择管理全文索引时;全文索引窗口显示消息... 创建全文索引不可用,请检查您是否有 关于要检查什么或下一步要去的任何想法?
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屋!