Full text searching in SQL Server 2008 Express Advanced

Posted by Iain Macleod on Stack Overflow See other posts from Stack Overflow or by Iain Macleod
Published on 2010-04-02T12:41:34Z Indexed on 2010/04/02 13:03 UTC
Read the original article Hit count: 340

Filed under:

full-text-search

Hi,

I have recently installed SQL Server 2008 Express Edition with Advanced Services on XP Pro but am having trouble getting full text searching to work with an restored database. The database was originally created in SQL Server 2005.

When I call a stored proc that uses the full text index then I get the following error: Full-Text Search is not installed, or a full-text component cannot be loaded.

This is my db version: Microsoft SQL Server 2008 (RTM) - 10.0.1600.22 (Intel X86) Jul 9 2008 14:43:34 Copyright (c) 1988-2008 Microsoft Corporation Express Edition with Advanced Services on Windows NT 5.1 (Build 2600: Service Pack 3)

When I run: SELECT DATABASEPROPERTY('DBNAME','ISFULLTEXTENABLED')

I get: 1

Also, when I look in the advanced properties for the db server in Management Studio I see both the "Default Full-Text Language" and "Full-Text Upgrade Option" properties. However, when I go to SQL Server Configuration Manager I don't see the "MSSQLFDLauncher" service.

Does anyone know how to get this working?

Cheers, Iain

Related posts about full-text-search

Error while configuring Sql server 2005 for full text search

as seen on Stack Overflow - Search for 'Stack Overflow'
I am trying to index a table for full text search on a SQL server 2005. When I select the change tracking as Automatic and click on the next button, I get the following error TITLE: Microsoft SQL Server This wizard will close because it encountered the following error: For help,… >>> More
Configuring Sql server 2005 for full text search

as seen on Stack Overflow - Search for 'Stack Overflow'
I am trying to index a table for full text search on a SQL server 2005. When I select the change tracking as Automatic and click on the next button, I get the following error TITLE: Microsoft SQL Server This wizard will close because it encountered the following error: For help,… >>> More
How to customize the full text search ?

as seen on Stack Overflow - Search for 'Stack Overflow'
Full text search is becoming a tedious job using the relational databases’ approach. Can anybody suggest an alternate option if any or way to customize the full text search ? >>> More
WHoosh (full text search) index problem

as seen on Stack Overflow - Search for 'Stack Overflow'
iam having the following problem with whoosh full text search engine. 1.After syncdb i am creating the intial index from the database objects. 2.it is working fine.I can able to search the data and see the results. 3.after that in one of my view i have added another document (via signals) to the… >>> More
How to implement full text search in Django?

as seen on Stack Overflow - Search for 'Stack Overflow'
I would like to implement a search function in a django blogging application. The status quo is that I have a list of strings supplied by the user and the queryset is narrowed down by each string to include only those objects that match the string. See: if request.method == "POST": form… >>> More

Developer IT