Contains not working - SQL Server Forums

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

SQL Server 2000 Forums

SQL Server Development (2000)

Contains not working

Author

Topic

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-05-26 : 02:14:03

When I run the query,

SELECT nn
FROM tt
WHERE CONTAINS(nn, 'test')

I get the error

Server: Msg 7601, Level 16, State 2, Line 1
Cannot use a CONTAINS or FREETEXT predicate on table 'tt' because it is not full-text indexed.

How can I set full-text index?

Madhivanan

Failing to plan is Planning to fail

Merkin
Funky Drop Bear Fearing SQL Dude!

4970 Posts

Posted - 2005-05-26 : 02:49:19

Did you look up full text indexing in BOL ?

Damian
Ita erat quando hic adveni.

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2005-05-26 : 03:09:56

Yes I checked. Full-text index is disabled
When I run this

EXEC sp_fulltext_database 'enable'

I got error
(1 row(s) affected)

Server: Msg 7609, Level 17, State 2, Procedure sp_fulltext_database, Line 46
Full-Text Search is not installed, or a full-text component cannot be loaded.

It seems that it was not installed.

Madhivanan

Failing to plan is Planning to fail

raclede
Posting Yak Master

180 Posts

Posted - 2005-05-26 : 04:48:20

before you can use the CONTAIN you must first create ftc..

"If the automobile had followed the same development cycle as the computer, a Rolls-Royce would today cost $100, get a million miles per gallon, and explode once a year, killing everyone inside. "

raclede™

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources