I use the FORMSOF(INFLECTIONAL, ...) when I create my searches from a = user's entry. A coworker has just pointed out that when she searches = for "financial", the search does not return matches with the word = "financials" it it. Is it possible to add this word pair to Full-Text search, or u...more >>

Has anybody every expirenced this, and if so, is there any way to repair the index as opposed to Rebuilding the index and then starting a full population on it. My table that's full-text indexed has over 12 million records in it, and it takes 5+ days to do a full population. Any ideas/advic...more >>

We have a database full of grocery items that we're trying to search. When I search for "*1%*" it seems that the percent sign is ignored and I get back all the rows that match "*1*" (which is A LOT). Is there anyway I can tell full-text search not to discard the percent sign and treat "1%" as ...more >>

I would like to ask if there are any books for beginners on full text search for sql server thanks! ...more >>

Hi: I have a FT cat with two tables in it: products, manufacturers and the tables each have a field in the FT Cat: "pname", "mname" each row in "products" has a field "mid" which corresponds to the same field in "manufacturers" when I run a query like: SELECT p.pname, p.p_id, m...more >>

Hi All: I have an FT Cat with 3 tables in it that I created 6 months ago. Each table in the FT Cat has "track changes" set to "automatic" There's no defined population schedule. Will this catalog be updated automatically when the data in the tables changes, or does it require a population...more >>

I recently redistributed our database data files from one large VRAID5 disk (G:) to 3 VRAID1 disks (T:, U:, V:). At this point, I have moved everything (including SQLAgent output & log files, job logs, tlogs, backups) EXCEPT: 1) FTDATA folder and its contents; 2) distmdl.mdf and distmdl.ldf...more >>

Does anyone know of any links to articles or information on creating a custom word-breaker and stemmer for full-text search on SQL 2005? In the meantime I'll keep Googling. Thanks ...more >>

Hello I have a slight problem, I have 4 fulltext catalogues that I cant remove using the: DROP FULLTEXT CATALOG SOMENAME that never finishes and cancel query doesnt work. How shall I drop those catalogues? The database havent got any tables with fulltext enabled on, still it wont let m...more >>

I've been asked to find a way of doing some complex searches against a SQL Server 2000 database using MSSearch. The company I'm contracting to wants to know if there is a way to perform a search such as: "sql" within x number of words of "database" (x could be any number) I'm not that ver...more >>

Hi there, I'm looking for some advice on the best methods / tools to implement an intranet search facility using ASP.NET and SQL2005. I need the ability to search both SQL Server content and files stored on the web servers file system (.doc, .xls, .pdf, etc). Is there one tool that will...more >>

Hello everyone, I have a very strange problem : I've installed SQL server 2005, create a storage for full index and full text index on a table. I've also installed Adobe IFilter. Searches are OK but only on one criteria I have problem. let me explain. I'm searching in files in database fo...more >>

Hello, I have installed SQL Server 2005 Express Edition with Advanced Services. Could you tell me please what should I do to enable full-text indexing? I have read in a book that I should run MSFTESQL service, but I don't know how. Will you help me? Thank you very much! /RAM/ ...more >>

I am trying to do some basic operation with FTS feature in SQLServer 2005. I have SQL 2005 and MSMSE (Management Studio Express). I also have downloaded/installed advanced featured from MS website. 1. Is it true with MSMSE I have no FTS/catalogs visual control ? 2. EXEC sp_configure 'default f...more >>

hi, out website is starting to get serious about switching from SQL 2000 to SQL 2005. in the process we hope to address a few weak points in our site's fulltext searching. i'd like to find the best possible documentation or courses to get up to speed on this. i have googled quite extensi...more >>

Sorry for the repost, but this really should have been the start of a new thread. Ok, that brings up another question, our server is set to boost SQL Server priority, would this slow down msftesql? We are running 4 3.2 Xeon's with 8 GB RAM (Maxmem is set to 7168 MB). We have 14 fulltext indexes...more >>

Our performance is currently fine, but we are planning on adding more full text indexes, so I have question. Our database server is experiencing between 2,000 and 10,000 page faults per second on msftesql.exe, as shown in task manager on the processes tab, is this normal for a relatively busy w...more >>

Hi, Is there a way to get the FTS system to return you the count of matches only, without passing back all the key ids. Basically if a user doesn't find what they are looking for with their initial multi term search, i.e '10k resistor tomatoes'. I want to display a list of the counts for ...more >>

Hi, in my SQL2005 db I have a table, with an image column containing a Word document. I have made a fulltext index on it. When I search for a specific phrase, I would like to return a snippet of the text where the searchcriteria was found. Is this possible to do this in SQL2005?? Or should I ...more >>

I want to index an address field so that I can do something like this: Select * from Table where Address between '400 main street' and '5600 Main Street' Is this possible w/ FTS or any SQL Server products? Thanks in Advance -- Rob Schieber ...more >>

Hello, I use a Free Text Catalog to optimize searching, but I have a problem. In my table there are many information about Ltd.s, like name, adress, and so on. I define the full text index on the column of names. I use neutral language settings, because our language wasn't on the list. (I...more >>

I have a SQL Server 2000 table with a varchar column (these are part numbers) that contains data like this: 145 145-SC 145-AB 145-2 145-8 The full text catalog also includes columns that hold part name and part description. I'm using the following query to return results for product sea...more >>

Hallo Everyone, To run full text search with PDF documents, there is an iFilter available from Adobe - at least for the x86 operating system. But I did not find an x64 version of this iFilter tool! Can anybody give me a hint where to find an appropriate version? Could also be payware! ...more >>

Hi, I use sql 2000 server and full text search. I would like to use fulltext thesaurus feature. Some how the thesaurus function does not work. What would be problem and how to solve it in SQL 2000 Server not SQL2005 we don't have enough money to upgrade it : ) ? Thanks There is a table ...more >>

Hi all, Today two tables in the same database ( which are the only ones with FTS in that database) had FTS disabled. I know for sure that yesterday both of them were enabled and working and nothing is showing in the logs about any change to the status ( apart from the normal automatic PAUS...more >>

I'm trying to get SQL Server to ignore the noise words for the Full-Text indexed content in a given column. I've edited the noise.eng and noise.enu files in the c:\winnt\system32 directory so they only have one word: qxqxqxq. So any other words will not be ignore and will get get indexed, right?...more >>

Hello I'm having problems with selecting a filegroup for the fulltext catalog. how should i fix this? Failed to finish full-text operation. Filegroup 'FULLTEXT' is empty, read-only, or not online. (Microsoft SQL Server, Error: 9964) ...more >>

Hi, I have a maintenance plan on my production server that does full-backup once every X days, the problem is that the DB is full-text enabled and has some live catalogs, but it seems that while backup is running the catalogs are offline which is unacceptable - checking the SQL log I find these...more >>

I'm getting some results from a CONTAINS query that I find odd. Here is MyTable: ID TheText ------------------------ 1 two AND three 2 two three and here is the query that I find odd: SELECT * FROM MyTable WHERE CONTAINS(*, '"two OR three"') that's a single quote followed...more >>

In SQL Server 2005 it seems that if multiple columns in a table are included in the FTI and you do a CONATAINS query using AND accross all columns all the terms must be in one column. Is this correct? Example: MyTable ID TheText MoreText ---------------------------------------...more >>

I have a large database that support 1,500+ concurrent users running an intense DB aplication. It currently supports scanning on documents(Using OCR) and images as LOB in the DB. These table are configured for their own filegroup so they can be on a different array then the relational data. ...more >>