How do I enable Full Text Indexing for MSSQL?

[eUKShane]

You need to use SQL Server Query Analyzer tool for this.

* This will enable full-text indexing for the current database:
exec sp_fulltext_database 'enable'

* This creates a catalog:
exec sp_fulltext_catalog 'catalogname', 'create'

* This enables indexing of a table:
exec sp_fulltext_table 'tablename', 'create',
'catalogname', 'indexname'

* This adds a column to an index:
exec sp_fulltext_column 'tablename', 'columnname', 'add'

* This activates fulltext on a table:
exec sp_fulltext_table 'tablename', 'activate'

* These two enable automatic filling of the full-text index when changes occur to a table:

exec sp_fulltext_table 'tablename',
'start_change_tracking'

exec sp_fulltext_table 'tablename',
'start_background_updateindex'

That's all

Best Regards,
UKShane
http://www.eukhost.com