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.
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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?
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.
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
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".