將下列中的藍色字體修改成你所要使用的資料庫環境, 再執行此 SQL, 該資料表就有全文檢索的功能 

---------------------------

use DatabaseName

go

exec sp_fulltext_database 'enable'

go

exec sp_fulltext_catalog 'ft_FAQ', 'create'

go

exec sp_fulltext_table 'FAQ','create', 'ft_FAQ', 'PK_FAQ'

go

exec sp_fulltext_column 'FAQ', 'ANS', 'add', 0x0404

go

exec sp_fulltext_column 'FAQ', 'FAQTYPE', 'add', 0x0404

go

exec sp_fulltext_column 'FAQ', 'FAQITEM', 'add', 0x0404

go

exec sp_fulltext_column 'FAQ', 'QST', 'add', 0x0404

go

exec sp_fulltext_table 'FAQ', 'activate'

go

exec sp_fulltext_catalog 'ft_FAQ', 'start_full'

go

exec sp_fulltext_table 'FAQ', 'start_change_tracking'

go

exec sp_fulltext_table 'FAQ', 'start_background_updateindex'

go