How to enable Full-Text Search
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 -
CREATE FULLTEXT CATALOG Database_Name AS DEFAULT;
CREATE FULLTEXT INDEX ON dbo.Table(Column) KEY INDEX PK_Index_Name;