全文搜索安装

本文介绍了全文搜索安装的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！ 问题描述

我已经安装了sqlserver2008. 但是在这种情况下，无法启用全文搜索. 当我执行"select fulltextserviceproperty(''isfulltextinstalled'')时，结果为0. 我不想失去我的这个实例.我应该怎么做才能启用此服务. 我正在Windows7上工作. 在此先感谢..:)

i have installed sqlserver 2008. But in that full text searching is not enabled. When i executed "select fulltextserviceproperty(''isfulltextinstalled'')" result was 0. I don''t want to lose my this instance. what should i do to enable this service.?? I am working on windows7. Thanks in advance..:)

推荐答案

要为表格启用全文索引 1.展开服务器组，再展开数据库"，再展开用户数据库"，然后展开包含要为全文索引启用的表的数据库. 2.右键单击要启用全文索引的表. 3.选择全文索引"，然后单击启用全文索引". 参考: msdn.microsoft/en -us/library/ms142536(v = sql.90).aspx [ ^ ] 否则尝试以下方法: To enable a table for full-text indexing 1. Expand the server group, expand Databases, expand User Databases, and expand the database that contains the table you want to enable for full-text indexing. 2. Right-click the table that you want to enable for full-text indexing. 3. Select Full-Text index, and then click Enable Full-Text indexing. Ref.: msdn.microsoft/en-us/library/ms142536(v=sql.90).aspx[^] or else try this: 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<