Full text searching in SQL Server 2008 Express Advanced

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

Additional: I tried to "generate SQL" for the full text index but I got the following error message: Full-text is not supported on this edition of SQL Server. (Microsoft.SqlServer.Smo)

This is very odd because according to the MS website it does suppor full text indexes: http://www.microsoft.com/express/Database/default.aspx#Installation_Options

I forgot, correct compatibility level should be "110".

jhexp 2010-04-02 13:03:17

Hi, thanks for your answer.The compatibility level was set to 80 so I tried setting it to 90 and to 100 but that didn't solve my problem.When I tried setting it to 110 I got the following error: Valid values of the database compatibility level are 80, 90, or 100.100 is SQL Server 2008.

Iain Macleod 2010-04-02 14:24:09

sorry, my bad, it should be 100. The latest error ("fulltext is not supported) you mention might be connected with the fact that fulltext indexes can't be scripted. Have you double checked if the fulltext engine is installed and running under accounts with sufficient rights? Otherwise I'm running out of suggestions.. :(

jhexp 2010-04-07 11:37:58

ansaurus

tags:

views:

answers:

Full text searching in SQL Server 2008 Express Advanced

related questions