Text Search not working on FileStream PDF File
I cannot get the Full-Text search to work on PDF files I am loading into my SQL Db via FileStream.
Version: SQL Server 2008 R2 (Developer Edition - doing proof of concept) OS: Windows 7
Steps I have taken.
Ran the below scripts to setup the new iFilter and make sure it is active
EXEC sp_fulltext_service @action='load_os_resources', @value=1; -- update os resources
EXEC sp_fulltext_service 'verify_signature', 0 -- don't verify signatures
EXEC sp_fulltext_service 'update_languages'; -- update language list
EXEC sp_fulltext_service 'restart_all_fdhosts'; -- restart daemon
EXEC sp_help_fulltext_system_components 'filter'; -- view active filters
Created the full-text index on the FileStream table I wanted to index
CREATE FULLTEXT INDEX on local.FILE_REPOSITORY
(DOCUMENT TYPE COLUMN FILE_EXTENSION)
Key Index PK_File_Repository ON
(FileSearchCat, FILEGROUP [PRIMARY]);
GO
Rebuilt Catalog
ALTER FULLTEXT CATALOG FileSearchCatREBUILD WITH ACCENT_SENSITIVITY=OFF;
Ran a query to see if the index is working
select *
from local.FILE_REPOSITORYwhere freetext(DOCUMENT, '25678')
Doesn't return any results for PDF, but works fine for word (docx)?
What am I doing wrong?
Ok so I figured it out....I needed to run these steps:
EXEC sp_fulltext_service @action='load_os_resources', @value=1; -- update os resources
EXEC sp_fulltext_service 'verify_signature', 0 -- don't verify signatures
EXEC sp_fulltext_service 'update_languages'; -- update language list
EXEC sp_fulltext_service 'restart_all_fdhosts'; -- restart daemon
EXEC sp_help_fulltext_system_components 'filter'; -- view active filters
But Also needed to run this!!!!
reconfigure with override
上一篇: 打包玩！ 应用程序直接进入WAR