How to enable full text search on SQL Server database?

Before enabling Full-Index search on a database table, you must have installed Full-Text search feature on SQL Server, if you think you haven't installed it, you can follow below steps

• On the Microsoft Windows Server system open the Control Panel > Programs and Features.
• Locate and select/highlight the Microsoft SQL Server version.
• Click Change.
• The installation wizard will open and choose Add / Modify.
• Click Next until the Feature Selection dialog
• Select the SQL Full-Text Search feature and install it.

Once you have installed SQL Full-Text Search feature, you can follow this step to enable or disable Full-Text indexing on Particular table of database

• Expand the server group, expand Databases, and expand the database that contains the table you want to enable for full-text indexing.
• Expand Tables, and right-click the table that you want to disable or re-enable for full-text indexing.
• Select Full-Text index, and then click Enable Full-Text index or Disable Full-Text index. (If you haven't defined Full-Text Index on the table, you may have to do that first)
  

To Enable a database for full-text indexing, you can use below sample query

USE Northwind
EXEC sp_fulltext_database 'enable'

Where 'NorthWind' is database name.