Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Other Technologies / Full-Text Search / May 2005

Tip: Looking for answers? Try searching our database.

SP4 and FT - can not find some words. Help...

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Oleg Cherkasenko - 13 May 2005 16:28 GMT
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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.