Skip to content

Instantly share code, notes, and snippets.

@fo40225
Created January 29, 2019 04:44
Show Gist options
  • Save fo40225/6a48733766953c2c4106810a0f8b4ac0 to your computer and use it in GitHub Desktop.
Save fo40225/6a48733766953c2c4106810a0f8b4ac0 to your computer and use it in GitHub Desktop.
sql server ifilter setting
-- https://www.microsoft.com/en-us/download/details.aspx?id=17062
-- https://supportdownloads.adobe.com/detail.jsp?ftpID=5542
-- https://helpx.adobe.com/acrobat/kb/pdf-search-breaks-110-install.html
-- add C:\Program Files\Adobe\Adobe PDF iFilter 11 for 64-bit platforms\bin to PATH
EXEC sp_fulltext_service 'verify_signature', 0
EXEC sp_fulltext_service 'load_os_resources', 1
EXEC sp_fulltext_service 'Restart_all_fdhosts'
EXEC sp_help_fulltext_system_components 'filter'
-- reboot?
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment