2012年(14)
分类: 数据库开发技术
2012-02-12 09:55:01
1- i have windows server 2008 and sql server 2008
2- i installed acrobat reader
3- i installed the Foxit PDF IFilter
4- i ran those commands in the console SQL Server 2008 :
exec sp_fulltext_service 'load_os_resources', 1
exec sp_fulltext_service 'verify_signature', 0;
5- I restart the sql service
6- i ran those commands in the console SQL Server 2008 :
exec sp_fulltext_service 'update_languages';
exec sp_fulltext_service 'restart_all_fdhosts';
7- I check if the filter is installed :
select document_type, path from sys.fulltext_document_types where document_type = '.pdf'
8- I create my catalogue
9- I create my full-text index and link it with the catalogue i already created.
10- I started the full Population