Full Text search must keep a list of key words or items somewhere.
How can I get access to this list to present to a user.
For example: show me all indexed words starting with letter a* and then ac*.
I'm trying to find this information without success.
Full Text uses only predicates so what you are asking are actually noise word and you can find the noise words for supported languages in the location below in your C drive. Hope this helps.
C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\FTData
|||As far as I know there is no way built in way to get the list from fulltext service as the data is stored natively by FTS.
Jens K. Suessmeyer
http://www.sqlserver2005.de
No comments:
Post a Comment