Full Text Search

Question

Full Text Search

stalin.d

SSC-Addicted

Points: 423
More actions
March 7, 2010 at 11:28 pm

#217642

Hi All,
I have a problem when i am trying to search some keywords in a particular column in a table. I get the following error.
"Cannot use a CONTAINS or FREETEXT predicate on table or indexed view 'tblArticles' because it is not full-text indexed."
can anyone pls help me in this?
[font="Times New Roman"]Thanks & Regards
Stalin.D[/font]

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Saurabh Dwivedy SSCommitted Points: 1887 More actions · Answer 1

Kindly make sure that you (or the authorized DBA in your organization) have created the full-text index on the column(s) you intend to search.

Saurabh Dwivedy
___________________________________________________________

My Blog: http://tinyurl.com/dwivedys

For better, quicker answers, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537

Be Happy!

stalin.d SSC-Addicted Points: 423 More actions · Answer 2

Hi,

Is there is any disadvantages in using full text search? will it affect the performance in anyways?

Please clarify.

[font="Times New Roman"]Thanks & Regards
Stalin.D[/font]

Saurabh Dwivedy SSCommitted Points: 1887 More actions · Answer 3

I suggest you refer to the following link on BOL http://msdn.microsoft.com/en-us/library/ms142591.aspx

This should hopefully shed more insight into the nature of full-text queries. Every feature comes with a set of advantages and disadvantages and caveats. There is no direct answer to your question in my opinion. But at the same time, I am not an expert so I cannot give you a quick birds eye view either of the whole process. Take a look at the link and see if it helps.

Regards

Saurabh Dwivedy
___________________________________________________________

My Blog: http://tinyurl.com/dwivedys

For better, quicker answers, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537

Be Happy!

stalin.d SSC-Addicted Points: 423 More actions · Answer 4

Hi,

Thanks for your reply.

[font="Times New Roman"]Thanks & Regards
Stalin.D[/font]

Mauve SSChampion Points: 11316 More actions · Answer 5

A very generic question. As with everything, "it depends".

Search the forums as there are numerous threads and topics related to your problem.

For starters, see the already published articles.

Some links for understanding and reference:

Hilary Cotter's article: http://www.simple-talk.com/sql/learn-sql-server/sql-server-full-text-search-language-features/

Full-Text Search Q and A http://msdn.microsoft.com/en-us/sqlserver/aa336328.aspx which contains the answer to the Question: why do we need full text if we can use "like" in select query?

Microsoft Technical Article SQL Server 2005 Full-Text Search: Internals and Enhancements

http://msdn.microsoft.com/en-us/library/ms345119(SQL.90).aspx which contains an answer (http://msdn.microsoft.com/en-us/library/ms345119(SQL.90).aspx#yukonftsea_topic2) to the question:

What Can Full-Text Search Do for Me?

[font="Arial Narrow"](PHB) I think we should build an SQL database. (Dilbert) What color do you want that database? (PHB) I think mauve has the most RAM.[/font]

stalin.d SSC-Addicted Points: 423 More actions · Answer 6

Hi Mauve,

Thanks for your reply.

It really helped me.

[font="Times New Roman"]Thanks & Regards
Stalin.D[/font]