SQL Server 2008 :: Full Text Search - Searching For Keyword

Apr 8, 2015

I am searching for the key word 'Platform Customer Support' using full text search. My code is as below

Set @KeywordSearch = 'Platform Customer Support'

Select AA, BB, CC, DD from SM9..TableName A Right Outer Join SM9_Experiment..TableName C
On A.IncdTouchedGSF like '%' + C.SM9GroupName + '%'
Where
(
Contains(A.[Description], @KeyWordSearch)
And A.OpenTime Between @StartDate and @EndDate
And C.Classification = @GroupNameClassification
)

The code is throwing:

Msg 7630, Level 15, State 3, Line 46
Syntax error near 'Customer' in the full-text search condition 'Platform Customer Support.

View 2 Replies


ADVERTISEMENT

Compensate For Keyword Density In Full Text Search

Apr 8, 2008

Hi,

When using FREETEXTTABLE the RANK returned seems to be partially based on keyword density. Has anyone come across a method of compensating for this keyword density so that good matches found in a lot of text and a small amount of text return the same RANK?

For an example look at the site I'm working on when someone searches for "whale watching" - http://www.yougodo.com/Search.aspx?ks=whale+watching - you can see that we are showing poor quality results at the top as our first sort order is based on RANK.

If we could remove the keyword density factor from RANK then this would allow second order sorting criteria to come in to play and move the more valuable results to the top.

Any help, pointers, advice would be greatly appreciated,
Gavin.

www.gavinharriss.com

View 1 Replies View Related

SQL Server 2008 :: Full Text Search On Indexed View

Mar 25, 2015

I'm creating Indexed view by JOINING multiple tables and trying to create FULL TEXT search index. Unique column is generated by concatenating to ID columns from different table. I can successfully able to create unique index however when trying to create FULLTEXT INDEX getting below error.

"A full-text search key must be a unique, non-nullable, single-column index which is not offline, is not defined on a non-deterministic or imprecise nonpersisted computed column, does not have a filter, and has maximum size of 900 bytes. Choose another index for the full-text key."

The message clearly says the column should be single-column index, non-deterministic.

View 0 Replies View Related

SQL Server 2008 :: Full-text Search Suddenly Returning Error

Jul 8, 2015

This morning, when I look at my error logs, the following appears;

Msg 0, Level 11, State 0, Line 0

A severe error occurred on the current command. The results, if any, should be discarded.

Msg 0, Level 20, State 0, Line 0

A severe error occurred on the current command. The results, if any, should be discarded.

If I remove the contains() part from the SQL Stored Procedure, it stills runs. So, in other words, suddenly contains() started making the query crash.

I'm running SQL Server 2008 R2.

View 0 Replies View Related

SQL Server 2014 :: Semantic Search Not Finding Keywords Identified By Full-Text Search?

Nov 6, 2014

I have a scenario of where the standard Full-Text search identifies keywords but Semantic Search does not recognize them as keywords. I'm hoping to understand why Semantic Search might not recognize them. The context this is being used in medical terminology and the specific key words I noticed missing right off the bat were medications.

For instance, if I put the following string into a FT indexed table

'J9355 - Trastuzumab (Herceptin)'
AND
'J9355 - Trastuzumab emtansine'

The Semantic Search recognized 'Herceptin' and 'Emtansine' but not 'Trastuzumab'

Nor in

'J8999 - Everolimus (Afinitor)'

It did not recognize 'Afinitor' as a keyword.

In all cases the Base of Full-Text did find those keywords and were identifiable using the dmvsys.dm_fts_index_keywords_by_document.It does show the index as having completed.

why certain words might not be picked up while others would be? Could it be a language/dictionary issue? I am using English and accent insensitive settings?

View 0 Replies View Related

Create Site Search Using Sql Server Full Text Search

Jul 24, 2007

would you use sql server "full text search" feature as your site index?  from some reason i can't make index server my site search catalog, and i wonder if the full text is the solution. i think that i wll have to you create new table called some thing like "site text" and i will need to write every text twice- one the the table (let's say "articles table") and one to the text. other wise- there is problems finding the right urlof the text, searching different tables with different columns name and so on...
so i thought create site search table, with the columns:
id, text, url
and to write every thing to this table.
but some how ot look the wrong way, that every forum post, every article, album picture or joke will insert twice to the sqr server...
what do you think? 

View 1 Replies View Related

How Can I Search Throught DOCX (MS Word 2007) Documents By SQL Server 2005 Full Text Search Engine?

Dec 11, 2006

How can I search throught DOCX (MS Word 2007) documents by SQL Server 2005 Full Text Search engine?

Should I something download?

View 6 Replies View Related

SQL Server 2000 Full Text Search (extract Pieces Of Text)

Sep 12, 2007

Hello everyone !
I want to perform Full Text Search with SQL Server 2000. My documents (.doc, .xls, .txt, .pdf) are stored in a SQL Server field which is binary (the type of the column is image).
I would like to know, how you can extract pieces of text from the documents.
Example:
I have a ASPX page with codebehind in C# making the search in a table in SQL server that is full text indexed.
I make a search looking for the word "peace", than SQL server will take care about the search and return it to me the rows that match with that. But also I'd like to extract the 50 characters before and after where sql server found the word "peace" to show in the result page.
Does anyone has any idea how to work around it ?
 Best regards.
Yannick

View 5 Replies View Related

Searching Database Text W/o Using Full-text Indexing

Mar 31, 2004

I am using the following plumbing code to search a database column for a keyword. I can't use full-test indexing so I came up w/ this work around. But It has many flaws so I'm looking for a better way. Thx in advance.

'Open sql connection
SqlConnection1.Open()

Dim datareader2 As SqlClient.SqlDataReader
datareader2 = cmdFindRowsWithKeyword.ExecuteReader
Dim strMsg As String
Dim intRowToFlag As Integer
Dim strRowsToGet As String
Dim strKeywordAsTyped As String
Dim strKeywordAllCaps As String
Dim strKeywordAllLower As String
Dim strKeywordFirstLetterCap As String
Dim FirstLetter As String

While datareader2.Read

intRowToFlag = datareader2(0).ToString
strMsg = datareader2(1).ToString

'Assign keyword as typed to variable
strKeywordAsTyped = txtSearchFor.Text
'Assign keyword as typed to variable then convert it to all uppercase
strKeywordAllCaps = txtSearchFor.Text
strKeywordAllCaps = strKeywordAllCaps.ToUpper
'Assign keyword as typed to variable then convert it to all lowercase
strKeywordAllLower = txtSearchFor.Text
strKeywordAllLower = strKeywordAllLower.ToLower
'Assign keyword as typed to variable then convert it so just the first letter is in uppercase
strKeywordFirstLetterCap = txtSearchFor.Text
FirstLetter = strKeywordFirstLetterCap.Chars(0)
FirstLetter = FirstLetter.ToUpper
strKeywordFirstLetterCap = strKeywordFirstLetterCap.Remove(0, 1)
strKeywordFirstLetterCap = strKeywordFirstLetterCap.Insert(0, FirstLetter)

'If the string contains the keyword as typed in all caps all lowercase or w/ the 1st letter in caps then flag that row.
If strMsg.IndexOf(strKeywordAsTyped) <> -1 Or strMsg.IndexOf(strKeywordAllCaps) <> -1 Or strMsg.IndexOf(strKeywordAllLower) <> -1 Or strMsg.IndexOf(strKeywordFirstLetterCap) <> -1 Then

cmdFlagRowsWithKeyword.Parameters("@recid").Value = intRowToFlag
SqlConnection2.Open()
Dim datareader3 As SqlClient.SqlDataReader
datareader3 = cmdFlagRowsWithKeyword.ExecuteReader
datareader3.Close()
SqlConnection2.Close()

End If
End While
datareader2.Close()

View 2 Replies View Related

SQL Server DB Full Text Search

Nov 6, 2004

Where do I find and enable full text search in sql server db?

I have hunted, and hunted, and stumbled, and looked with no luck.

Should it have been installed during set up?

Thanks all,

Zath

View 1 Replies View Related

SQl Server Full Text Search

Jul 19, 2005

I have a server that has windows 2000 with Sql Server Enterprise edition sp3 installed and we are currently using the full text catalogs. I have another server that we have are trying to use the full text catalogs and it does not populate the catalog. I have check the microsoft search service to make sure it is logged in the same. I have gone through and recreated the catalogs twice and they will not populate. Can anyone give me any suggestion of things I can look for, Please ??

View 12 Replies View Related

Full Text Searching

Jan 4, 2008

how can install full text searching in SQL SERVER  2005
 By mohsen

View 1 Replies View Related

Full Text Searching

Jan 5, 2008

how can TRUE full text indexed property in column property in SQL server 2005?
by mohsen

View 1 Replies View Related

Full-text Searching

Jan 6, 2008

how can enabled full-text searching in sql server 2005 on windows XP?
Thanks, mohsen

View 2 Replies View Related

Full-text Searching

Jan 10, 2008

do support full-text searching for sql 2005 express edition? thanks,mohsen

View 1 Replies View Related

Full-text Searching

Jan 16, 2008

how can enabled full-text searching for table columns for sql server 2005 enterprise edition?

View 1 Replies View Related

Full Text Searching

Mar 9, 2004

I am trying to run a full text serach on one field, a Varchar 2000.
say the field contains:
(before you break the seal of your new product box, please be careful to read all the instructions) ...for example
I search for keywords that may be in this field
Like:
product box
seal
instructions
and this row is included in the result set

but I would like to leave out words like all pronouns and 'a' and 'I' ...words that aren't going to matter to the search.

Does someone know where I can stgart in doing this full text searching?

Thanks,
Eric

View 3 Replies View Related

Full-Text Searching

Oct 16, 1998

I`ve just starting playing around with version 7.0 and was wondering if anyone knows how to implement the Full-text Searching feature. Its sound like a neat feature if I could just get it to work.
Thanks in advance
Joe

View 2 Replies View Related

Full Text Searching

Mar 20, 2007

I've assumed responsibilty for a sqlserver 2000 that has many databases and has only 1 database that uses full text searching. That 1 application now wishes for me to update the noise words file to remove the single characters.

As far as I can tell, no other application is using the full text searching since I don't see any catalogs created for any of them.

So, if no other databases and applications in this sqlserver have catalogs created for them, can I safely assume that changing the noise words file will not impact any of them even if the other databases do have text fields in some tables?

View 2 Replies View Related

Full Text Searching

Dec 3, 2005

Hi i am really new to full text searching, I have created a catalog using:
sp_fulltext_catalog 'textcatalog','create'

and now i want to add a table with:
sp_fulltext_table 'Product', 'create','textcatalog', 'ProductID'

where product is a table in my database and productID is the primary key to that table. The primary key cannot be null,

But i get an error:
'ProductID' is not a valid index to enforce a full-text search key. You must specify a unique, non-nullable, single-column index.

Can any one point me in the right direction?

Thanks in advance

Tuppers!

View 3 Replies View Related

CONTAINS In Full Text Searching

Aug 3, 2007

Hi

I've used CONTAINS on a varchar field.
in SQL SERVER 2000

the query was "Select name from description where CONTAINS(name,' "donot*" ')

say if I search for "Select name from description where CONTAINS(name,' "donot a*" ')
---it doesn't return rows.

as might be it is seeing that 'a' as the starting letter of AND key word which is used in CONTAINS
but how to tell that it is my next letter in the search

Really I need more clarity on this...

Thanxs in advance

View 8 Replies View Related

Full-text Searching

Mar 1, 2007

Are there any plans to add full-text searching capability to SQLCE? I know it's available in SQL Server Express but it would still be useful for an embedded/desktop application -- SQLite recently added this.

View 1 Replies View Related

Sql Server: Msg 7607 - Full Text Search

May 30, 2006

hi,

i am getting the above error message when trying to do full text search with containstable on a single table.

i am dynamically creating the search querry condition and some times its even having 18 times "AND" OR "AND NOT" in the search condition.

i have read in MS bug list that there is a limitation of length of the search string while doing FTsearch. it said that its been fixed in SP3 of sql server 2000.

But i am still getting the error 7607 even after installing SP3 on my server.

need advise on resolving this issue..

prad

View 3 Replies View Related

Full Text Searching With Paramters

Feb 28, 2008

i have a query in SQL Server 2005 that uses a parameter like so:ALTER Procedure [dbo].[p_FullTextEquipmentSearch]

@search as nvarchar(50),

as

SELECT * FROM EquipmentView

where contains(*, @search);

 what i want to so is add more parameters to the query so that the user can choose either 1 or many for the search can anyone help me on this

View 2 Replies View Related

Question About Full Text Searching

Mar 18, 2004

Hi,

I was wondering when is it worth using Full Text Searching as opposed to using LIKE? Also, since I will be using third party for hosting my site, generally, do hosts support Full Text Searching?

Thanks!

View 1 Replies View Related

Problem With Full Text Searching

Jun 8, 2005

I'm wrtiting a local site search egine but I need to make use of functions like FREETEXTABLE
for instance. In order to use this I have to have the' Full Text Search
table' enabled for a table. Now the Microsoft Search Service is running
in MSDE; of that I'm sure. However when I try to enable the full text
searching on a table or database the option that I'm supposed to choose
is grayed out which means I can't select it. What's wrong? What do I
have to do to be able to use that option? I' short of time and would
appreciate n answer a.s.a.p. Thanks

View 3 Replies View Related

Indexing,full Text Searching

Dec 30, 2005

hello friends..

do indexing and full text searching needs cideamon.exe ?

cideamon exe eats much cpu.I want to disable it but I am afraid that disabling cideamon.exe affects mssql indexes to work.

thanks

View 3 Replies View Related

PROBLEMS WITH FULL TEXT SEARCHING

Dec 29, 2005

I am very new to SQL and Access projects.

I have created the full text catalogs for my tables, so that I can search all the tables at the same time, from any of the fields in the catalogs.

I have created the following procedure:-

create procedure usp_full_text(@findtext varchar(255))
as
select set_id as URN, input_date as date_of_record from set_records where freetext (*, @findtext)
There are a few union selects under this, but

If I search for perhapse 'SMITH' from within access, then this will bring back all the records which have smith in them somewhere, which is good, however if I repeat the search for 'smit' then I get no records returned.

How can I change the code to find the parts of words, or string of charactors, and how can I set this to do a soundex search?

Hopefully all this is possible, i just need pointers on how to achieve this, or I could be sat there for days.

Many thanks for any help you can offer.

View 1 Replies View Related

Full-Text Search In SQL Server 2005 Express

Feb 8, 2007

I installed SQL Server 2005 express with advanced services which is supposed to include full-text search capability but I can't get it to work.  When I try to create a full-text catalog it gives me an error because it does not think the full-text service is installed or loaded.  I can't seem to find a reference to the full-text search feature to enable or install it.  any ideas?

View 3 Replies View Related

Full Text Search - Wildcards (SQL Server 2005)

Feb 5, 2008

the sql server documentation states that the use of wildcards is allowed by placing an '*' at the end of the search term.  I can get this to work OK in the SQL Server 2005 query window, heres an example
select ID, SUBSTRING(Title, 1, 100) AS Title, Implemented, Published from Table1 where contains(title,'"Therap*"') ORDER BY Title
 
this works OK and returns a list ot titles with the word Therapy in the title
  Im trying to implelemnt this functionalty in a web app with C#.  The string is passed to a stored procedure.  How on earth do I pass in the quotes ??
Ive tried building the string as normal then adding single quotes on the end, so I get something like
retval = txt + "*";    //txt contains the partial word im searching for, then add the wildcard
then  retval = "'" + retval + "'";  // add the single quotes
and pass txt as a string parameter to my stored procedure.  It doesnt work.  Can anyone tell me what im doing wrong ??
the same query works fine in the SQL query window.

View 7 Replies View Related

Full Text Search On Clustered SQL Server 2000

Jun 21, 2005

I am using SQL Server Enterprise 2000 and have created a full text search on the pubs database as per the instructions below:-

http://www.databasejournal.com/features/mssql/article.php/3441981

However, when I verify the search :-

SELECT title, notes
FROM titles
WHERE CONTAINS (notes, ' "quick easy" ')

no rows are returned.

In the full text tab under the pubs database, my demo catalog is listed, but the Item count and unique key count are both 1. There are 18 records in my titles table.

The full text files location is on my H drive which is set up as a dependency of SQL Server in cluster admin.

In SQL EM->Support Services->Full Text Search->properties, the location of my temporary files was set to C:winnt empgthrsvc. As nothing in cluster admin can see this directory, I changed it to H: emp but still no data is returned by the query. There is no default error log file listed and I can't work out how to change this.

I have checked the Search service is running under the local system account.

I can't find any error messages which may indicate a problem apart from the fact that the T-SQL query doesn't return any data.

Anyone any ideas? Any help is much appreciated.

Thanks in anticipation.

Claire

View 3 Replies View Related

SQL 2012 :: Full Text Search On Production Server?

Jan 29, 2014

Full Text Searches are working on my test server, but not on my production server. My test scenario is as follows:

CREATE FULLTEXT CATALOG FTC_Test
AS DEFAULT
AUTHORIZATION dbo

CREATE FULLTEXT INDEX ON guest.FtsTest(FullName)
KEY INDEX PK_FtsTest ON FTC_TestI wait briefly and then check to see if the index has been populated:
SELECT * FROM sys.fulltext_indexescrawl_end_date is not null,

So I'm assuming I don't have to wait anymore before I try some FTS searches. Right? I can't get any queries to return anything, though.

The following tells me the full text item count for the table is zero:

DECLARE @TableId INT
SELECT @TableId = id FROM sys.sysobjects WHERE [Name] = 'FtsTest'
SELECT OBJECTPROPERTYEX(@TableId, 'TableFulltextItemCount') AS TableFulltextItemCount

As mentioned, the full text search works on my test server. Both of them are SQL 20012 SP1 (11.0.3000) x64 running on WinServer 2008 R2 SP1.

View 3 Replies View Related

SQL Server 2012 :: Full-Text Search On FileTable

Apr 11, 2014

I am new to Full-Text Searches and FileTables. I am working on a resume search system. I created a FileTable and the Share which contains about 51,000 resumes in Word (DOC/DOCX), PDF and TXT formats that were copied over from our main file server. I followed the instructions on adding the Microsoft Filter Pack 2.0, and all searchable file types are listed in sys.fulltext.document_types.

I have a program that searches resumes by First and Last Name and/or E-mail Address. For a while, we thought it was working fine because we were getting hits, but then we noticed some Names and E-mail Addresses we new existed were not showing up in my CONTAINS queries -- but we verified the documents do exist and the Names exist in the File Name and inside the document along with the E-Mail address.

One example I'm working on now cannot find the First/Last Name with CONTAINS(name,"lastname") in a Word DOC file, but I can find the document using LEFT(name,5) = 'Smith'. It's a Word DOC file. For testing purposes, I opened the DOC file in Word, then used Save As to create a TXT and DOCX file within the same folder. Now, both of those are showing up in the CONTAINS but not the original DOC file.

View 0 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved