I´m working on my university senior project about a Search Engine and I
´m using SQL08 Full-Text.
I´m trying to get all the inflectional forms for all words for an
improvement.

Is it possible to create a second FT-INDEX for the same table?  I want to
index different fields in each one to use it in different areas.
Alternatively, is it possible to do a FT search on MULTIPLE fields in an
Index?   I know that the FREETEXTTABLE can only do it on either one ...

after migrating from SQL Server 2005 to SQL Server 2008 I was faced with a
brainteaser that led to a lot of discussions in my team.
Let me sketch the problem:
There is a large database with a varchar(1000) column – say 20 millions

I am using the FTS to run a search through an web application. (asp.net)
Is it possible to pickup that the theasurus file has replaced a search word
so that I can indicate this to the user via the website?
thanks.

Is it possible to retrive the search result to highlight the text where it
found the text searched?
Like google i mean.
Thanks,

I get really slow results for full text search queries. By slow I mean
5 seconds average.
Let me describe what I did so far.
I created a simple table: id,title,description,firstTopic,longTopic.

I have a Windows Server 2003 box running WSS 2.0 and SQL Server 2000.
I've turned on full text indexing in WSS2.0 but I'm getting error
messages indicating that it can't find the appropriate iFilters for
the docs I'm storing (.doc and .pdf).