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.
| Author |
Topic |
|
amirs
Constraint Violating Yak Guru
260 Posts |
Posted - 2009-05-11 : 02:52:03
|
| dear alli have select a table to use free text seacrh likeselect colnm from dbo.tabnm where FREETEXT (col,'950')but display the following errCannot 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 ShawSQL Server MVP |
 |
|
|
|
|
|