SMO:此版本的SQL Server不支持全文本 [英] SMO : Full-text is not supported on this edition of SQL Server

问题描述

我的sql server 2005有问题.
在实施全文搜索应用程序之前，我安装了sql server 2005 Advanced服务.
现在在我的应用程序中，当我检查服务器上是否安装了Fulltextservice时，它返回true，
但是当我想访问数据库全文目录时，应用程序将引发此异常:
此版本的SQL Server不支持全文."

尽管我实现了全文搜索，但是当我在应用程序中执行搜索时，它可以完美地工作.
我想知道为什么行会引发异常.
我花了两天时间没有找到解决办法.
这是我的源代码:

I have a problem with my sql server 2005.
I installed sql server 2005 Advanced service before implementing Fulltext search application.
Now in my application when i checked if Fulltextservice is installed on the server it return true,
but when i want to access the database fulltextcatalogs the application throws this exception:
"Full-text is not supported on this edition of SQL Server."

Although I implemented fulltext search and it works perfectly when i performed search in the application.
I wondering why the line throws exception.
I spent 2 days on this without finding solution.
this is my source code:

srv = new Server(_instancename)

if (srv.IsFullTextInstalled == true)//this line return true
{
 Database db = srv.Databases["jorce"];
 if (! db.FullTextCatalogs.Contains("JorceFTCat"))//this line throws exception: "Full-text is not supported on this edition of SQL Server."
 {
 FullTextCatalog ftc = new FullTextCatalog(db, "JorceFTCat");
 ftc.IsDefault = true;
 ftc.Create();
 }
}

我很困惑.
感谢您的帮助.

I''m confused.
Thanks for the help.

推荐答案

下载Sql Server 2008的最新累积更新.

或按照此链接 [ ^ ]进行讨论.

Download the latest Cumulative Update of Sql Server 2008.

Or follow this link[^] for the discussion.

这篇关于SMO:此版本的SQL Server不支持全文本的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！