Track-It! 20.xx: How to check if FullTextSearch Feature is installed on the SQL Server

Knowledge Article

Track-It! 20.xx: How to check if FullTextSearch Feature is installed on the SQL Server
Track-It! 20.xx: How to check if FullTextSearch Feature is installed on the SQL Server
Track-It!
Track-It! 2021 R2
Track-It! 20.xx and above
Track-It!
Track-It! 2021 R2
Track-It! 20.xx and above
Note:
Track-It! uses the Full Text search feature that is available only with Advanced Services variant of SQL Server and SQL Express to perform the Search function.

How to check if 'Full Text Search' Feature is installed on the SQL Server?
To find if the existing SQL Server has this feature turned on, run the following query against the server.

SELECT

CASE

WHEN

FULLTEXTSERVICEPROPERTY('IsFullTextInstalled') = 1

THEN

'INSTALLED'

ELSE

'NOT INSTALLED'

END IsFullTextInstalled

Screenshot 2024-09-17 011920.png
Another way to find out if this feature is installed is to look at the list of services on the machine. If full text search is installed, you'll see a service named SQL Server FullText Search ([instance]) where [instance] will be the name of the SQL instance that it is associated with.

 
Track-It!
Track-It! 2021 R2
Track-It! 20.xx and above
Attachment(s):