全文搜索安装 [英] Full text search installation

问题描述

我已经安装了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.选择全文索引"，然后单击启用全文索引".

参考: http://msdn.microsoft.com/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.: http://msdn.microsoft.com/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<

这篇关于全文搜索安装的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！