How to turn on the FULLTEXT mode on SQL Server 2005

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

First I want to create the catalog:

  • Select most recent dates
  • Does extracting rows from an SqlDataSource using directcast cause another trip to SQL Server?
  • Visual Studio 2010 Reporting Services Projects?
  • Need help on indexing using SQL server 2005
  • Unique constraint with EFCodeFirst and SqlCe4
  • Multiply columns in T-SQL join query
  • USE [AspDotNetStorefront]
    EXEC sp_fulltext_database 'enable'
    CREATE FULLTEXT CATALOG searchcatalog 

    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 Express 9.0.4053 and I have SQL Server Management Studio Express (9.0).

    One Solution collect form web for “How to turn on the FULLTEXT mode on SQL Server 2005”

    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

    MS SQL Server is a Microsoft SQL Database product, include sql server standard, sql server management studio, sql server express and so on.