Is there a way to get a list (programmatically) of the words that SQL Server
expands a user’s search word to for inflectional search?
Example:
1.    User searches “run”

We are currently using a 3rd party Search Engine to search our application
content in SQL server.
Could someone please point me to Benchmark data for the FTS service? I am
interested in switching to FTS even if the Performance numbers are comparable

Hi All: I just stumbled across this post, noting that you can create a view
against multiple tables, and then use the view in the full-text index, so
that if you do a freetexttable query agains the view, you are in effect
searching multiple tables simulataneously.

I have an instance of SQL Express 2005 with the Advanced Tools
installed on an XP machine.  I can turn on full text in the DB
property window but there are no other nodes in the management studio
for full-text.  There's no storage node or other menu/properties for

I have a T-SQL query uses Contains,i have setup the index on my table,My
Question is: How can i pass column value to contains function in T-SQL,My
Query as follows:
SELECT Distinct

I'm trying to populate a full text index on a database but I'm having some
troubles.  
I've tried re-creating the index, re-populating it fully, and even
incrementally all to no avail. The full text catalog for this table still

Good Day,
I have noticed this warning in my SQL Server 2005 log. The full message
reads:-
Warning: Failed to get MSFTESQL indexer interface for full-text catalog

Please read this two threads first, as this all started on .newusers
(I'm one of them)
More relevant: (http://tinyurl.com/454uav  http://preview.tinyurl.com/454uav)
http://groups.google.com/group/microsoft.public.sqlserver ...

I'm trying to implement full-text search for the albanian language. What's
the best way to implement it?
Based on my current understanding the most feasible way is to:
1. Use one of the supported lnaguages, for example Turkish.

Can any one point me to right direction for renaming of full text
index file name.  I have full text indexing on a table and I have to
rename this file without droping and receating full text indexing. For
example

From start to finish, what queries do I give to enable fulltext (if
not enabled), create catalog, create and populate index for a table?
I do not want to use any UI for this. I'm using SQL 2005.
Regards,