/
How to setup FTS component in MSSQL

How to setup FTS component in MSSQL

Full-Text Search in SQL Server component and run full-text queries against character-based data in SQL Server tables.

Full-Text Search is an optional component of the SQL Server Database Engine. If you didn't select Full-Text Search when you installed SQL Server, run SQL Server Setup again to add it.

More information available on https://docs.microsoft.com/en-us/sql/relational-databases/search/full-text-search?view=sql-server-2017

How to add FTS feature to an Instance

Following document provides a step-by-step procedure for adding features to an instance of SQL Server.

https://docs.microsoft.com/en-us/sql/database-engine/install-windows/add-features-to-an-instance-of-sql-server-setup?view=sql-server-2017

Full-text search component can be selected from the available features list, when adding new features to the existing MSSQL server edition. 

Availability of the Full-text search component depends on the SQL server edition (see the table below).

Features Supported by the SQL Server Editions 

Related content

Tuning cardinality estimation
Tuning cardinality estimation
More like this
Tuning cardinality estimation
Tuning cardinality estimation
More like this