How to turn on the FULLTEXT mode on SQL Server 2005

Question

Hi,

I'm currently trying to create FULLTEXT indexes into my database (Microsoft SQL Server 2005).

First I want to create the catalog:

USE [AspDotNetStorefront]
GO
EXEC sp_fulltext_database 'enable'
GO
CREATE FULLTEXT CATALOG searchcatalog 
GO

But that doesn't work, the result is this:

Msg 7609, Level 17, State 100, Line 1
Full-Text Search is not installed, or a full-text component cannot be loaded.

I'm running on Windows XP, SQL Server 9.0.4053 and I have SQL Server Management Studio Express (9.0).

Answer 1

Full-Text search is only available in the SQL Express Advanced versions, see Features Supported by the Editions of SQL Server. Get 2005 from Microsoft SQL Server 2005 Express Edition with Advanced Services, 2008 from Microsoft SQL Server 2008 Express with Advanced Services