Sql Server 2008 Express with full text search

full-text-search sql-server-express
Kim picture Kim · Jul 18, 2011 · Viewed 8.2k times · Source

I wanted to try out the fts feature of sql server 2008 express. According to the product page (http://www.microsoft.com/sqlserver/en/us/editions/express.aspx) , there should be fts included in the download.

Offers reporting capabilities, full-text search, and spatial support

The download i get is SQLEXPRWT_x64_ENU.exe, 260 megs in size, and when i run the installer, there is no mention of fts. Still i try install it with all features (Select All), and when the install is done, i test to create a fts catalog. The catalog is created but when i try to edit and add tables, i get errors.

Property IsAccentSensitive is not available for FullTextCatalog '[CatalogName]'

and

Property PopulationStatus is not available for FullTextCatalog

These errors indicate that full text search has NOT been installed. (Here)

Now, i also read on the above stackexchange question that the installer that includes fts is larger than 200 megs, it should be like 800 megs, so that is another clue that my installer does not contain fts. Not only that but the link in the above question is redirected to the product page linked first in my question.

Does anyone know how to get the express version WITH full text search?

Answer

jimben picture jimben · Jan 19, 2012

You have to install SQL Server Express With Advanced Services in order to get Full Text Search functionality. http://www.microsoft.com/download/en/details.aspx?id=25174

Related questions

Express with Advanced Services, can't create Full Text Index

I have installed SQL Server 2012 Express Edition Advanced Services which states that it includes Full-text indexing. Here is a link that states this: http://msdn.microsoft.com/en-us/library/cc645993.aspx I have confirmed that Full-text service is running, however …

Read More
How do I insert Chinese characters into a SQLExpress text field?

How do I insert Chinese characters into a SQLExpress text field? I'm using SQL Express from VS 2008. When I add Chinese characters, either via an import app I wrote or by pasting them in from the data view inside Visual …

Read More
Vim clear last search highlighting

After doing a search in Vim, I get all the occurrences highlighted. How can I disable that? I now do another search for something gibberish that can't be found. Is there a way to just temporarily disable the highlight and …

Read More