Install Full-text on SQL Server

1

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?

    
asked by anonymous 09.03.2017 / 15:12

1 answer

1
  

Is this a feature that should be downloaded, or is it already in my SQL Server and just need to enable it?

Full-text search is an optional SQL Server database engine component. Because SQL Server is already installed, you must then follow the script Add features to an instance of SQL Server 2014 . On the "Feature Selection" page, select the "Full-Text and Semantic Extractions for Search" option, as shown below.

According to the document Features Supported by SQL Server Editions 2014 , this feature is available in the Enterprise, Business Intelligence, Standard, Web, and Express with Advanced Services editions. Note that Express with Tools and Express editions do not offer this feature.

  

How do I use Full-Text on my SQL Server ?

In the Full-Text Search document you find information about the use of the resource.

    
09.03.2017 / 23:52