Hello,
I have installed SQL Server 2005 Express Edition with Advanced Services.
Could you tell me please what should I do to enable full-text indexing?
I have read in a book that I should run MSFTESQL service, but I don't know
how. Will you help me?
Thank you very much!
/RAM/

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


[quoted text, click to view]

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
--
Hilary Cotter

Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com



[quoted text, click to view]

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



[quoted text, click to view]