本文介绍了全文搜索安装的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我已经安装了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<
更多推荐
全文搜索安装
发布评论