Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Other Technologies / Full-Text Search / June 2007

Tip: Looking for answers? Try searching our database.

pdf ifilter issue with sp_fulltext_service

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Dlorbecki - 06 Jun 2007 15:53 GMT
Several internet posts I've read describe how to get SQL Server to recognize
a 3rd party ifilter .dll.  This involves the use of sp_fulltext_service with
the following syntax:

Exec sp_fulltext_service 'verify_signature', 0
Exec sp_fulltext_service 'load_os_resources', 1

I've used these commands and have been able to get SQL Server and SharePoint
to build an index for pdf documents.  Many of these instructions tell you to
reverse the settings after you're finished in order to better secure the
server.  Those commands are:  

-- Restore the Full-text service settings to their default
Exec sp_fulltext_service 'verify_signature', 1
Exec sp_fulltext_service 'load_os_resources', 0

The problem is, that once you run the above commands and reboot, you no
longer index any new pdf files added to the server.  Is this the expected
behavior?  If not, what am I doing wrong?  I don't want to leave the security
hole open by not running these commands but then you don't index new files.
Dlorbecki - 07 Jun 2007 20:33 GMT
This is a duplicate post I created because I did not see my original after a
day of waiting.  Please disregard this post and use the other.  Thanks.

> Several internet posts I've read describe how to get SQL Server to recognize
> a 3rd party ifilter .dll.  This involves the use of sp_fulltext_service with
[quoted text clipped - 16 lines]
> behavior?  If not, what am I doing wrong?  I don't want to leave the security
> hole open by not running these commands but then you don't index new files.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.