Posted by Erland Sommarskog on 02/11/06 21:13

(james_oinn@hotmail.com) writes:
> We have 2 SQL Server 2005 machines. One has the CTP version installed,
> the other is the RTM.
>
> When running the query below, results are returned for the CTP version
> but not the RTM version.
>
> select * from table t1
> inner join containstable(table, column, 'formsof(inflectional,
> ''bücher'')') t2
> on t1.[id] = t2.[key]
>
>
> I have checked that the same data is present in the tables on both
> machines and also that the FTI has been fully populated with a status
> of "idle".
>
> Please note that the word used "bücher" is a German word and should
> return "buch" as a match.
>
> Is this a bug with the RTM version of SQL Server 2005??

Since I don't know fulltext, I cannot answer. Maybe you should try
microsoft.public.sqlserver.fulltext.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: How to configure a JBOD disk array (PowerVault) for Performance
• Prev in forum: Re: one for the SQL experts - dare I say TRICKY SQL!
• Thread view: Re: SQL Sever 2005 - Full Text FormsOf Inflectional

[Reply to this message]