我试图在sql Server 2005 Express中启用全文索引.我在Vista Ultimate的笔记本电脑上运行.
我了解sql Server Express的标准版本没有全文索引.我已经下载并安装了“Microsoft sql Server 2005 Express Edition with Advanced Services Service Pack 2”(download).
我还确保“sql Server(实例)”和“sql Server FullText搜索(实例)”服务都在与“网络服务”相同的帐户上运行.
我可以运行SQL查询“SELECT fulltextserviceproperty(‘IsFulltextInstalled’);”并返回1.
我遇到的问题是,当我在设计视图中打开表格并选择“管理全文索引”;全文索引窗口显示消息…
“Creation of the full-text index is not available. Check that you have the correct permissions or that full-text catalogs are defined.”
关于什么检查或下一步去哪里的任何想法？
解决方法
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
