requirements: SQL Server 2008 Developers Edition
- Create FulText catalog
- Execute command:
CREATE FULLTEXT INDEX ON dbo.Files(content TYPE COLUMN extension)
KEY INDEX PK_id ON dmsFTCatalog
WITH CHANGE_TRACKING AUTO
3. You can view filters when the following commands are executed:
select * from sys.fulltext_document_types
select * from sys.fulltext_index_columns
4. Download .pdf filter: http://www.adobe.com/support/downloads/detail.jsp?ftpID=2611.
5. Execute the following commands against your Sql Server 2005 instance.
sp_fulltext_service ‘load_os_resources’,1. This command tells the Microsoft Search Service to load OS specific wordbreakers, stemmers, and such.
sp_fulltext_service ‘verify_signature’, 0. Do not verify that the binaries are signed.
6. Bounce the Sql Server Service and MSFTESQL.
7. Issue the necessary command(s) to (re)index:
exec sp_fulltext_catalog ‘dmsFTCatalog’,’start_full’
useful links:
http://weblogs.asp.net/wallym/archive/2005/02/28/382060.aspx
http://jtkane.spaces.live.com/Blog/cns!33DA9EBF0ACF8558!537.entry
http://arcanecode.wordpress.com/category/sql-server-full-text-searching/
