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

Hello Guys,

Although I installed full text search in my SQL. It was showing this error.

I checked by using SELECT FULLTEXTSERVICEPROPERTY('IsFullTextInstalled') property and it displays 1 as result means full text search is installed i think. Please give the suitable options to resolve this error.

Thanks

February 19th, 2015 9:35am
Have you checked if there is already a full text search on the table?
Free Windows Admin Tool Kit Click here and download it now
February 19th, 2015 9:40am

No..

February 19th, 2015 10:51am

Hi,

You need to create the full text index in the table using something like below in order to use the full text search.

CREATE FULLTEXT INDEX ON TableName(ColumnName) --This is the column where you would like to perform the search
   KEY INDEX [PrimaryKeyColumnORAnyIndexColumn]

Regards,

Brindha.

Free Windows Admin Tool Kit Click here and download it now
February 19th, 2015 11:06am
I  got this...Thanks Brindha
February 20th, 2015 5:37am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics