"Oleg Cherkasenko" <oleg@opel.com.ua> wrote in message
news:eoLwxB9VFHA.584@TK2MSFTNGP15.phx.gbl...
> 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" <oleg@opel.com.ua> wrote in message
news:OQABhT9VFHA.2748@TK2MSFTNGP10.phx.gbl...
> May be this: ???
> http://www.dbforums.com/archive/index.php/t-1150044.html
>
>
> "Oleg Cherkasenko" <oleg@opel.com.ua> wrote in message
> news:eoLwxB9VFHA.584@TK2MSFTNGP15.phx.gbl...
> > 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.
> >
> >
> >
> >
> >
> >
> >
> >
> >
>
>

"Hilary Cotter" <hilary.cotter@gmail.com> wrote in message
news:%23FktnfCWFHA.3716@TK2MSFTNGP12.phx.gbl...
> Did you try some of the suggestions in the post, and did they work for
> you?
>
> --
> 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
>
> "Oleg Cherkasenko" <oleg@opel.com.ua> wrote in message
> news:OQABhT9VFHA.2748@TK2MSFTNGP10.phx.gbl...
>> May be this: ???
>> http://www.dbforums.com/archive/index.php/t-1150044.html
>>
>>
>> "Oleg Cherkasenko" <oleg@opel.com.ua> wrote in message
>> news:eoLwxB9VFHA.584@TK2MSFTNGP15.phx.gbl...
>> > 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.
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>> >
>>
>>
>
>