I have already created SQL Server database, but when I am trying to run a query that requires full-text search enabled database, it is not working and throwing error
Cannot use a CONTAINS or FREETEXT predicate on table or indexed view 'tblLocation' because it is not full-text indexed.
So, how can I enable full-text index to remove above error?
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
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
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.
Subscribe to our weekly Newsletter & Keep getting latest article/questions in your inbox weekly