Network Programming in .NET

After hunting on the net, and in books for ages, I figured out how to set up a full text catalog using stored procedures

exec sp_fulltext_database @action=’enable’
exec sp_fulltext_catalog @ftcat = ‘TableName’,@action=’create’
exec sp_fulltext_table @tabname=’TableName’, @action=’create’,@ftcat=’TableName’,@KeyName=’PK_TableName’
EXEC sp_fulltext_column ‘TableName’,’SomeTextColumn’,’add’
…
EXEC sp_fulltext_table ‘TableName’,’activate’
exec sp_fulltext_table @tabname=’TableName’, @action=’start_full’

You need to have the MSSearch (support service) running on the SQL server, and this doesn’t work in MSDE.