Home
> Uncategorized > SQL server 2000 – Full text search
SQL server 2000 – Full text search
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.
Categories: Uncategorized
Comments (0)
Trackbacks (0)
Leave a comment
Trackback