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:

  • In SQL server how do I order table rows by insertion order if primary key is GUID?
  • How to get only number from string in SQL Server?
  • Is there a simple tool for adding users to a SQL Server database?
  • SQL Server 2008 Full-Text Search (FTS) extremely slow when more than one CONTAINSTABLE in query
  • Sql server version problem when database restore
  • SQL Unique constraint across multiple tables
  • 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.