Why do 2019 DBs appear to have FTS enabled when FTS is not installed?

Saransvan 106 Reputation points
2023-01-12T10:46:55.1033333+00:00

If I look at a DB on a SQL Server 2019 without FTS installed - in properties, files 'Use Full-text indexing' is ticked and greyed out.

However it looks exactly the same on a server when FTS is actually installed and running!

Can anyone explain this please?

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
14,323 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Saransvan 106 Reputation points
    2023-01-12T11:29:43.85+00:00

    Ah, just found this on the Help page.

    This check box is checked and disabled because full-text indexing is always enabled in SQL Server.


  2. Seeya Xi-MSFT 16,486 Reputation points
    2023-01-13T02:41:32.1533333+00:00

    Hi Saransvan,

    First, you need to make sure that you are not using Express Edition, because this edition does not support full-text search. Please see: https://learn.microsoft.com/en-us/sql/sql-server/editions-and-components-of-sql-server-2019?view=sql-server-ver16#Programmability

    User's image

    Secondly, you need to check if this feature is successfully installed.

    SELECT FULLTEXTSERVICEPROPERTY('IsFullTextInstalled') 
    AS [FULLTEXTSERVICE]
    

    If the above query returns “1” then, it means that the full-text search feature is installed and enabled. And if the query returns “0” then, it means that the feature is not installed.

    Best regards,

    Seeya


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.