SQL Server Freetext and Contains functions at Godaddy webhosting

Question

I have a webhosting at Godaddy with MS-SQL, I have a table called Product with 3 columns (Id, Title, Details)

I want to implement Freetext or Contains function to search multiple words.

When I execute the query: Select * from Product where freetext(Title,'Car Honda')

It answers me "Cannot use a CONTAINS or FREETEXT predicate on table or indexed view 'Product' because it is not full-text indexed."

I google the topic and found that I need to CREATE Full-text Index First. At Godaddy I just have a web Query Analizer because have not been able to open my database using Microsoft SQL Server Managment Studio.

One of the sites that I found is this: http://dnnblog.venexus.com/MS+SQL+Server+FullText+Indexing+Info+Dump.aspx

Explain step by step how to Create Full text Index, also using scripts: EXEC sp_fulltext_database 'enable' EXEC sp_fulltext_table 'BrainDump', 'create', 'BrainDumpCatalog', 'PK_BrainDump' EXEC sp_fulltext_column 'BrainDump', 'IndexWashedContent', 'add' EXEC sp_fulltext_table 'BrainDump', 'activate' EXEC sp_fulltext_table 'BrainDump', 'start_full'

When I run the first single line EXEC sp_fulltext_database 'enable' I receive an error "User does not have permission to perform this action"

Does anyone has been success to use FreeText or Contains at Google, or what another option do you suggest me to have those kind of search?

Answer 1

From this page:

GoDaddy do not support full text catalog on their shared ASP.NET hosting plans, so you should get at least a VPS hosting with them to use that option. The other approach is to find a shared ASP.NET hosting company like discountASP, which support Full Text Catalog.