I am using the Freetext predicate to search a column to search for phrases and variations on phrases. So say I just use a single phrase to search on e.g. 'enquiry' it will return variations such as 'enquire', 'enquiry', 'enquires' etc. This works fine. What I would like, is when I display the...more >>

Hello, is there the chance to personalize the word braker rules for italian language on SQL 2005? We need to index a lot of "ancient textual corpora" and modern rules do not works fine. thanks ...more >>

Hi there, is there an easy way to run a full text search on a SQL Server 2000/2005 Standard/Workgroup Edition without installing the enterprise edition? It's just for testing purposes .. Many Thanks, JM ...more >>

Hi, I have a problem with a request concerning chineese data on a nText field... Here is a sample: TABLE : T FIELD : TXT as nText I insert this value on my table : ? [???] ??????????? Now i'd like to query my table to retrieve rows containing an exact match to my only line SELECT...more >>

Hi everyone, We have a SQL-Server 2000 DB with Full-Text-Search enabled on some of the tables. We have one table with about 15 million records. The table looks like ...more >>

Hi guys, one of my customers moved a SQL Database from one server to another. The database had 2 fulltext catalogs associated. On the new DB Server the fulltext service doesn't start using sp_fulltext_database 'enable'. QA shows "Executing Query Batch..." but never returns. I googled on the ...more >>

I actually need to understand where I could see a complete list of noise words. # is not in the noise word list. Is it a token boundary? Where is the complete list of these? Currently we are fighting fires as these errors occur. ...more >>

We are getting the dreaded "A clause of the query contained only ignored words." error when a user searches for the following term: "3.0" (without quotes). I've checked all the noise word lists and "3.0" is not in there. "3" is however. Also, when one searches for "3.1" it's fine - no error. ...more >>

I've just discovered that the CONTAINS clause on sql2005 can search multiple columns - great! Is there a way to return which column the search word(s) were found in? Dunc ...more >>

Hello, I have a full-text enabled field in my table has the following content as an example: "SQL Server is a comprehensive, integrated, end-to-end data solution that empowers your people by providing a more secure, reliable, and productive platform for enterprise data and BI applications. SQL...more >>

If I open a SQL 2000 database using the management console the Full-Text options are grayed-out / disabled...even though Full-Text search service is started and I can create full-text catalogs using stored procedures in QA and search using those catalog in QA. This problem occurs on my local...more >>

Hi Thomas, I see your problem. Let me think about the best solutions. Most of FTS users are focus in get great functionality to efficiently search inside a document, rather than to search parts in different documents stored in different columns. Anyway, for these cases like yours, we support m...more >>

Hi Thomas, I am afraid SQL 2005 shows the same behavior. FTS is designed to search for text/documents, which normally are stored in the same column. Can you please explain a bit more why you need to have queries that involve several word matches for several columns? Thanks! Fernando Azpeiti...more >>

I noticed that we were getting no results in our search this morning. The records were in the DB, search terms matched when using "LIKE" but not CONTAINS. Once I did a repopulation (incremental) all worked fine. What I don't understand is that the repopulation is actually scheduled to run each d...more >>

Hi, I understand that full-text indexing is not available in the express edition. My situation is that we have to write an application to take advantage of full-text-indexing when available. Quesitions are. 1. Does "freetext" and "contains" queries works on express edition? (by doing a ...more >>

Hi, My users must be able to do a full text search, and add items to the database if they aren't in yet. But once an item is added, in a lot of cases they need it directly after it. But when they search for it after the insert, the article isn't found... It takes at least 10 seconds befo...more >>

Hi Guys, I have Windows Server 2003 for Small Business Server. I am trying to make the full-text searches work with Sharepoint. I initially didn't have MSSearch installed so I went ahead and started the install for SQL Server 2000 and selected the sharepoint instance of the database (which us...more >>

My clients need to be able to search on identification numbers that are formatted like '5-1' or '10-23'. In the first instance, I can't do it at all, because the wordbreaker breaks 5 and 1 apart, then ignores both as noise words. In the second case, I get a bunch of stuff back that has 10 ...more >>

I have a sharepoint WSS content databse which as a few fulltext indexes defined (docs, lists, UserData, UserInfo tables). On the WSS site, search does not return any hits. I have start a full population of the catalog, that did not seem to make any difference. Properties for the catalog sho...more >>

I'm search on multiple columns useing FREETEXTTABLE, is there a way to know which column contained the search string? Be low is my query: SELECT C_ID, ( C_LNAME + ', ' + C_FNAME) as C_NAME, C_SIT1, C_SIT2, C_SIT3, C_SIT4, C_SIT5, C_SIT6, C_SIT7, C_SIT8, C_SIT9, C_SIT10, c_city, c_zi...more >>

Hi All I cannot get Filtdump.exe to run. I have a server where MS SQL FullText search is working perfectly (PDF, Office, HTML etc.) but when I run FiltDump.exe on one of the PDFs I the following message: C:\>temp\Filtdump.exe test.pdf FILE: test.pdf load filter search log++++: Error 0xc0000...more >>

Hi there, After having posted on question on the sharepoint.windowsservices newsgroup an MVP has redirected me to this newgroups saying that maybe someone over here could help me as Sharepoint is leveraging the SQL Server Full Text Search capabilities. So here goes my original posting: O...more >>

hi, i'm using SQL Server 2000 (SP3, I think). i am looking at SQL for finding documents (table DOC) based on a couple of criteria, one of which involves a fulltext index on a related table (TXT). i discovered today that a less selective CONTAINS() clause: CONTAINS (txt_stripped, 'dai...more >>

Hello gurus, We haved started using sql server 2005 and now queries saved to files in unicode format instead ansi. We badly want our ansi format. How can we do this? Many thanks JJ ...more >>

I've written a script which crawls a website and saves all pages and documens (pdf, doc etc) to a MS SQL database. The MSSQL Fulltext service then indexes the documents and the search (CONTAINSTABLE) works wonderfully. My problem is that when displaying the results, I want to dispaly the "rea...more >>

Hi I have a full text indexed xml column in sql server 2005 containing the following xml snippet: <plays> <folder id="681"> <page id="3155"> <submitdate>12-10-02</submitdate> <pagetext>Horatio says 'tis but our fanta...more >>

Hi, We have XML data stored in a table and are wanting to full text this data. We are using Quilogic Ifilter to get just the contents of the attributes. Test XML files return the required info (and the settings have been written out). So I think this is setup correctly. ie. blob contains...more >>