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 / July 2007

Tip: Looking for answers? Try searching our database.

freetexttable issue

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
ibaldwinjr@gmail.com - 19 Jul 2007 14:19 GMT
Hi,

I am using freetexttable as a search tool for our application but it
seems that it is partially working. I am able to search on some words
specified in my catalog but not on others. For example I got keywords
- stamps business cards. The freetexttable function can pick up only
'stamps' but not 'business'. I created another record in the table
included in the catalog and have the same keywords. Now I can search
on 'stamps' of the first record but not on the second record.

here is the code snippet:

select * from freetexttable(<table name>, *, 'keywordhere')

where: tablename is included in the catalog
          keywordhere is the keyword in which i use 'stamps' or
'business'.

Any help is greatly appreciated.

thanks!
Baldwin
Hilary Cotter - 19 Jul 2007 20:14 GMT
Can you try this

select * from freetexttable(<table name>, *, 'Stamps')

select * from freetexttable(<table name>, *, 'business')

select * from freetexttable(<table name>, *, 'Cards')

Do the same rows show up?

Signature

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

> Hi,
>
[quoted text clipped - 18 lines]
> thanks!
> Baldwin
 
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.