KBA-01226: Full-text Indexing in SQL Server


How can I tell if Full-text Indexing is installed in Microsoft SQL Server?


In Query Analyzer, run the following command:

          SELECT fulltextserviceproperty('IsFulltextInstalled')

1 = installed

0 = not installed

Additional Comments:

In SQL Server 2000 Enterprise Manager, check for the Full-Text Catalog folder under the Databases. In SQL Server 2005 Management Studio, check in the Database | Storage folder for a Full Text Catalogs folder.

KBA-01226; Last updated: December 19, 2019 at 21:57 pm;