Tuesday, 21 July 2015

SQL: How to Check if FullText Search is Installed

  • SELECT FULLTEXTSERVICEPROPERTY('IsFullTextInstalled')
If 0 => it's not installed. Otherwise, it's installed.

To install, run through the installer and simply add Full Text Search from the Features page.

  • SELECT * FROM sys.fulltext_catalogs
  • Check if you are able to add a new Catalog when you right click Storage > Full Text Catalog.
  • In SQL Configuration Manager, is there Full Text Daemon Launcher service?
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)