I want to use the full-text index in my SQL Server 2014.
I've created a catalog with the command:
CREATE FULLTEXT CATALOG [noticiasFullText] WITH ACCENT_SENSITIVITY = OFF
And when I was creating the full-text index in my table with the command:
CREATE FULLTEXT INDEX ON Noticias
(titulo LANGUAGE 1046, descricao LANGUAGE 1046)
KEY INDEX idnoticia
ON noticiasFullText
WITH STOPLIST = OFF
You gave the following error:
Mensagem 7609, Nível 17, Estado 5, Linha 4
A pesquisa de texto completo não está instalada ou não é possível carregar um componente de texto completo.
Then I looked for how to install Full-text in my SQL Server, but without success. Is this a feature that should be downloaded, or is it already in my SQL Server and just need to activate it?
How do I use Full-Text in my SQL Server?