Loading...

Knowledge Base
Categories: ,

How to enable Full-Text Search

Share

95% of our servers already come with Full-Text search capabilities. If you receive an error from the below commands, please contact support to have it enabled on your server.

You may use the article available at CREATE FULLTEXT CATALOG (Transact-SQL) to enable full-text search by inputting the commands into your MSSQL Management Studio client once you've connected to our MSSQL server. An example set of commands is as follows -

USE Database_Name;
GO
CREATE FULLTEXT CATALOG Database_Name AS DEFAULT;
GO
CREATE FULLTEXT INDEX ON dbo.Table(Column) KEY INDEX PK_Index_Name;
GO
 

Did you find this article helpful?

 
* Your feedback is too short

Loading...