I am using SQL 2005 and SQL Server Management Studio.
How can I activate FullText in my database?
Or should I do this only for the tables where I need it?
How can I do this?
Thank You,
Miguel
Try the thread below I have posted most of the information you will need and why it may not work in Express and if you are in Express the second thread covers some work around solution. Hope this helps.
http://forums.asp.net/thread/1460813.aspx
http://forums.asp.net/thread/1446828.aspx
I am not able to activate thesaurus in SQL Server 2005. With some help I was able to use noise files but thesaurus is uphill. The following is my tsENU.xml file:
<XML ID="Microsoft Search Thesaurus">
<thesaurus xmlns="x-schema:tsSchema.xml">
<diacritics_sensitive>0</diacritics_sensitive>
<expansion>
<sub>ANTHONY</sub>
<sub>TONY</sub>
</expansion>
</thesaurus>
</XML>
All I want is, ANTHONY and TONY to be treated as synonymous.
The following is my query:
SELECT CONTACTID, FULLNAME
FROM CONTACT
WHERE CONTAINS (FULLNAME, ' FORMSOF (THESAURUS, TONY) ')
and
SELECT CONTACTID, FULLNAME
FROM CONTACT
WHERE FREETEXT (FULLNAME, 'TONY')
To no awail. Am I missing some thing here? Kindly help me to go thru this.
I even restarted the sqlftservice and recreated the index but to no use.
thanks and regards
SQLDBA123
Here is an example thesaurus file:
<XML ID="Microsoft Search Thesaurus">
<thesaurus xmlns="x-schema:tsSchema.xml">
<diacritics = false/>
<replacement>
<pat>W2K</pat>
<sub>Windows 2000</sub>
<sub>NT</sub>
</replacement>
<replacement>
<pat>Internet Explorer</pat>
<sub>IE</sub>
<sub>IE 5</sub>
</replacement>
<replacement>
<pat>Internet</pat>
<sub>intranet</sub>
</replacement>
<expansion>
<sub>run</sub>
<sub>jog</sub>
</expansion>
<replacement>
<pat>seek</pat>
<sub>went</sub>
</replacement>
</thesaurus>
</XML>
Please replace the corresponding thesaurus with this example and restart msftesql service. Now thesaurus should work. The problem is that the example in the thesaurus file is wrong on diacritics setting property.
thanks,
Jingwei
I am not able to activate thesaurus in SQL Server 2005. With some help I was able to use noise files but thesaurus is uphill. The following is my tsENU.xml file:
<XML ID="Microsoft Search Thesaurus">
<thesaurus xmlns="x-schema:tsSchema.xml">
<diacritics_sensitive>0</diacritics_sensitive>
<expansion>
<sub>ANTHONY</sub>
<sub>TONY</sub>
</expansion>
</thesaurus>
</XML>
All I want is, ANTHONY and TONY to be treated as synonymous.
The following is my query:
SELECT CONTACTID, FULLNAME
FROM CONTACT
WHERE CONTAINS (FULLNAME, ' FORMSOF (THESAURUS, TONY) ')
and
SELECT CONTACTID, FULLNAME
FROM CONTACT
WHERE FREETEXT (FULLNAME, 'TONY')
To no awail. Am I missing some thing here? Kindly help me to go thru this.
I even restarted the sqlftservice and recreated the index but to no use.
thanks and regards
SQLDBA123
Here is an example thesaurus file:
<XML ID="Microsoft Search Thesaurus">
<thesaurus xmlns="x-schema:tsSchema.xml">
<diacritics = false/>
<replacement>
<pat>W2K</pat>
<sub>Windows 2000</sub>
<sub>NT</sub>
</replacement>
<replacement>
<pat>Internet Explorer</pat>
<sub>IE</sub>
<sub>IE 5</sub>
</replacement>
<replacement>
<pat>Internet</pat>
<sub>intranet</sub>
</replacement>
<expansion>
<sub>run</sub>
<sub>jog</sub>
</expansion>
<replacement>
<pat>seek</pat>
<sub>went</sub>
</replacement>
</thesaurus>
</XML>
Please replace the corresponding thesaurus with this example and restart msftesql service. Now thesaurus should work. The problem is that the example in the thesaurus file is wrong on diacritics setting property.
thanks,
Jingwei
