sql全文檢索的使用說明

--移除全文檢索
USE ServerLog;
GO
EXEC sp_fulltext_table 'tmp', 'drop';
GO

--建立全文檢索資訊
USE ServerLog;
GO
EXEC sp_fulltext_table 'tmp', 'create', 'tmp', 'PK_100and10';

--Add some columns
EXEC sp_fulltext_column 'tmp','MsgText','add';
-- Activate the full-text index
EXEC sp_fulltext_table 'tmp','activate';
GO
--重建索引資料匣
USE ServerLog;
GO
EXEC sp_fulltext_catalog 'full28', 'rebuild';
GO

--索引狀態確認
USE ServerLog;
GO
EXEC sp_fulltext_table 'tmp', 'Start_change_tracking';
EXEC sp_fulltext_table 'tmp', 'Start_background_updateindex';
GO