On the SQLServer SP3 my stored procedure worked fine.
I have install SP4 and rebuild FT catalogs. I dont delete and create new,
but only rebuild.
Now for example, I entered word 'putin' and 'rasputin' into table with ft
indexed column.
Stored procedure found word 'putin'
1.select * from dbo.strings_catalog xp where
CONTAINS(xp.*,'FORMSOF(INFLECTIONAL,putin)')
2.select * from dbo.strings_catalog xp where CONTAINS(xp.*,'putin')
and can not find
1.select * from dbo.strings_catalog xp where
CONTAINS(xp.*,'FORMSOF(INFLECTIONAL,rasputin)')
2.select * from dbo.strings_catalog xp where CONTAINS(xp.*,'rasputin')
If I update record
Update dbo.strings_catalog set name='putin' where 'rasputin'
then ok, this records found also.
After this:
Update dbo.strings_catalog set name='rasputin' where 'putin'
this record not found.
Oleg Cherkasenko - 13 May 2005 16:59 GMT
May be this: ???
http://www.dbforums.com/archive/index.php/t-1150044.html
> On the SQLServer SP3 my stored procedure worked fine.
> I have install SP4 and rebuild FT catalogs. I dont delete and create new,
[quoted text clipped - 18 lines]
> Update dbo.strings_catalog set name='rasputin' where 'putin'
> this record not found.
Hilary Cotter - 14 May 2005 02:54 GMT
Did you try some of the suggestions in the post, and did they work for you?

Signature
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
> May be this: ???
> http://www.dbforums.com/archive/index.php/t-1150044.html
[quoted text clipped - 21 lines]
> > Update dbo.strings_catalog set name='rasputin' where 'putin'
> > this record not found.
Oleg Cherkasenko - 19 May 2005 16:18 GMT
I have deleted and created FT catalogs. Then full populated and start change
trackimg, background updating.
Now its look like working.
> Did you try some of the suggestions in the post, and did they work for
> you?
[quoted text clipped - 26 lines]
>> > Update dbo.strings_catalog set name='rasputin' where 'putin'
>> > this record not found.