开启全文索引
2010-06-02 11:00 kenty06 阅读(117) 评论(0) 编辑 收藏 举报
use Resource
go
if(select databaseproperty('Resource','isfulltextenabled'))=0
execute sp_fulltext_database 'enable'
execute sp_fulltext_table 'tbl_Dat','create','FT_Resource','UPKCL_titleidind'
execute sp_fulltext_column 'tbl_Dat','Dat_Value','add'
execute sp_fulltext_table 'tbl_Dat','activate'
execute sp_fulltext_catalog 'FT_Resource','start_full'
go
if(select databaseproperty('Resource','isfulltextenabled'))=0
execute sp_fulltext_database 'enable'
execute sp_fulltext_table 'tbl_Dat','create','FT_Resource','UPKCL_titleidind'
execute sp_fulltext_column 'tbl_Dat','Dat_Value','add'
execute sp_fulltext_table 'tbl_Dat','activate'
execute sp_fulltext_catalog 'FT_Resource','start_full'