3
Answers

SMO : Full-text is not supported on this edition of SQL Server error

Photo of mouss mouss

mouss mouss

14y
3.5k
1

I  use sql server 2005 advanced service (i desinstalled sql server 2005 for the advanced edition in order to implement fulltext search).


It works perfectly when i create the FullTextCatalog and Fulltextindex. All the sripts i executed  in sql server management studio work fine.


Now I have finished to developp the application. And i want to check if  the selected database contains a specific catalog, but i got error message "SMO : Full-text is not supported on this edition of SQL Server" althougth the service exists for the server


This is my code source:


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 need help. I'm confused


Answers (3)

0
Photo of Nikunj Satasiya
NA 1.5k 144.6k 7y
It's may Web Browser issue. You can delete/clear stored Cookies from the web browser or you should UnInstall an older version of browser and install New version of that browser or also you can update it withot uninstallation.