Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 problem in free text search

Author  Topic 

amirs
Constraint Violating Yak Guru

260 Posts

Posted - 2009-05-11 : 02:52:03
dear all
i have select a table to use free text seacrh like
select colnm from dbo.tabnm where FREETEXT (col,'950')
but display the following err

Cannot use a CONTAINS or FREETEXT predicate on table or indexed view 'dbo.tabnm' because it is not full-text indexed.
so what is the err

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2009-05-11 : 03:41:18
Is the table dbo.tabnm included in the full text indexes that you've got set up?

--
Gail Shaw
SQL Server MVP
Go to Top of Page
   

- Advertisement -