Hello R.A.M.,

The service should be running. Looking in Services in adminstrator tools
and there should be an entry for SQL Server Full Text (SQLEXPRESS). Makre
sure it is started.

Then when you create a database make sure you check the enable full text
checkbox.

Or you can run the following after you have created the database. Have a
look in Books Online for more information

sp_fulltext_database 'enable'

Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons

I would first off verify that SQL FTS is installed. To do this issue the
following command via Query Analyzer, or SQLCMD.

SELECT FULLTEXTSERVICEPROPERTY('isfulltextinstalled')

A value of 1 indicates it is. To run this via SQLCMD do the following at a
command prompt:

sqlcmd -S.\SQLServerExpressInstanceName -E -Q"SELECT
FULLTEXTSERVICEPROPERTY('isfulltextinstalled');"

Now if this comes with a 1, it is a matter of creating your SQL FTS indexes
and catalogs from the command line; here is an example
save this as C:\myscript.sql

USE FullTextDatabase
GO
create fulltext catalog MyCatalog as default;
GO
create fulltext index on mytable(charcol) key index mytablepk;
GO
alter fulltext index on mytable enable;
GO

sqlcmd -S.\SQLServerExpressInstanceName -E -i"c:\MyScript.sql"

Then do the following

One more thing: in SSMSE (SQL Server Studio Management Express) you
don't have much visual control on the full-text features.

I have checked:
SELECT FULLTEXTSERVICEPROPERTY('isfulltextinstalled')
return 0 so full text search is not installed. But I had checked it to be
installed during setup.

I have a question: could you tell me the URL from which I should download
SQL Server 2005 with full text search? I have downloaded SQLEXPR_ADV.EXE and
SQLEXPR_TOOLKIT.EXE from Microsoft's download center but maybe it's not
proper version...
Please help.

/RAM/