Knowledgebase: MSSQL
|
How to enable Full-Text Search
Posted by Arvand Sabetian (Import) on 03 June 2010 06:17 AM
|
|
|
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 http://msdn.microsoft.com/en-us/library/ms189520.aspx 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 | |
 (29 vote(s)) Helpful Not helpful |
Comments (4)
Aaron Gusman
25 May 2011 05:02 AM
Hi,
SQL Server Full-Text Search requires the use of an XML file that is used as a Thesaurus. For instance in a thesaurus one could place the terms "GB", "Gigabyte", and "Gig" so that a search with any of these three synonyms will achieve the same results. Does Arvixe support the uplaoding or modfication of such XML Thesaurus file? This especially because the file cannot be manipulated using SQL statements.
Read the following articles for reference:
http://technet.microsoft.com/en-us/library/ms345187.aspx
http://technet.microsoft.com/en-us/library/ms142491.aspx
Thanks
Aaron Gusman
http://aarongusman.wordpress.com/
SQL Server Full-Text Search requires the use of an XML file that is used as a Thesaurus. For instance in a thesaurus one could place the terms "GB", "Gigabyte", and "Gig" so that a search with any of these three synonyms will achieve the same results. Does Arvixe support the uplaoding or modfication of such XML Thesaurus file? This especially because the file cannot be manipulated using SQL statements.
Read the following articles for reference:
http://technet.microsoft.com/en-us/library/ms345187.aspx
http://technet.microsoft.com/en-us/library/ms142491.aspx
Thanks
Aaron Gusman
http://aarongusman.wordpress.com/
Arvand Sabetian
02 June 2011 11:11 PM
Hello Aaron,
Unfortunately not on our shared hosting. But on our VPS/Dedicated you certainly can.
Unfortunately not on our shared hosting. But on our VPS/Dedicated you certainly can.
ananymous seeker
14 August 2012 01:04 AM
Is full text search supported in mysql too in shared asp.net hosting on arvixe?
Michael Carr
14 August 2012 03:51 PM
Yes, MySQL has support for full-text searches so long as you setup the database appropriately.