SQL 文件内容存储表 创建索引

exec sp_fulltext_database 'enable'

exec sp_fulltext_catalog 'CATE_DOC_FILES', 'create'

exec sp_fulltext_table 'CM_BSS_DOCFILES', 'create', 'CATE_DOC_FILES', 'PK_C'



exec sp_fulltext_column 'CM_BSS_DOCFILES', 'FILECONTENT', 'ADD',0x0804,'FILETYPE'

execute sp_fulltext_table 'CM_BSS_DOCFILES', 'activate' 

execute sp_fulltext_catalog 'CATE_DOC_FILES','start_full' 

start_incremental


exec sp_fulltext_database 'enable'

exec sp_fulltext_catalog 'CATE_DOCFILES', 'create'

exec sp_fulltext_table 'CM_BSS_DOCFILES', 'create', 'CATE_DOCFILES', 'PK_C'



exec sp_fulltext_column 'CM_BSS_DOCFILES', 'FILECONTENT', 'ADD',0x0804,'FILETYPE'

execute sp_fulltext_table 'CM_BSS_DOCFILES', 'activate' 

execute sp_fulltext_catalog 'CATE_DOCFILES','start_full'