Hi SQLserver 2000 enterprise + sp3 I have fulltext search on a Text column of a table. The fulltext has column change tracking, updateindex in background set up. When i ran the query, select * from contacts where contains(*,'"HOME*"') and userid = 534 , it is returning only 5 ro...more >>

Hi, I have enabled full text search on the products table. It works as expected most of the times but does not return any thing for keyword like IL-8. Please try searching for IL and IL-8 on this page(http://4.19.91.45/bs/searchresult.asp). The noise.eng file does not have any numbers in it...more >>

We have two tables that have full text indexes, currently both are using the same catalog. One table is much larger and the column being indexed contains more data. Would there be any advantage of seperating the indexes into tow seperate catalogs? Kyle! ...more >>

I've had a FT-indexed database working for a month or so - have had no problems with it. This is SQL Server 2000, SP3a. There are 50,000 rows in the table in question, and new rows are not being added, nor are the existing rows changing - they've been static since they were originally insert...more >>

Anyone have any experience building large full text indexes on SQL Server 2005. I am trying to build a 100 Million row index using Full-Text 2005 JUNE CTP. My average row size is about 500 chars in a varchar field. Index build performance is progressively slowing down. I started out with ...more >>

So I've edited all copies of noise.enu (the correct file foe US English) by removing 'c' from the line with the alphabet. I did restart on the Indexing service and forced a full population on the two tables we have fulltext indexes on. Of course I've missed something...since when I run a q...more >>

I did this on my new production server. I rebooted the server and forced a full rebuild of the indexes. The server still tells me my query only contains noise words. It worked correctly on the old production server and on our dev server. What did I miss? Kyle ...more >>

Dear sirs, How to set full-text indexing on table which has multi-columns as primary key? Thanks ...more >>

Is there a way to specifically add ".NET" or "C++" so that they WILL be indexed inside of word or rtf docs? Or is there a replacement IFilter that will do it? Kyle! ...more >>

I am posting this question here in the hopes that someone else has seen this issue and might have a remedy, because I have as of yet not been able to pin down the exact solution to the problem experienced. I will include all details of the problem along with remedies already tried to avoid ...more >>

I went and edited all three instances of the noise.eng files on the server. I forced the server todo a full population of the indexes. The problem is, of course, it finds every instance of the letter "C", not only when it occurs by itself, but even when it occurs inside a word. Help! K...more >>

I have provided an .Net component to modify the thesaurus files for Sql Server FTS. After writing the thesaurus file, I re-start the MSFTESQL Service and execute a query that will invoke the thesaurus file. Instead of returning a resultset, I get an event log entry as follows: Unicode byt...more >>

Hello. I hope someone can help me with this one. We have an SqlServer2000 database SP3, running on Win2003 server. On of the tables in one of the databases we use the fulltext search, and we have set up schedules jobs, one doing a incremental population on the catalog every hour from 07.00 ...more >>

hi, I have response problem with Full Text Index which is 600MB in Size and growing incrementally. Previously we had 128MB Ram and 350MB of index size then size of index increases to 600MB due to insertion of data after this performance degraded so we increased the RAM to 256MB now performance...more >>

Hi All, The table I'm using has full-text columns and also a date column thats indexed. If I do a query on a date range and the full-text column does SQL Server return the full-text rows first, then subset by date, or subset by date and pass that set of rows to MSSEARCH? I'm wondering about...more >>

Thanks for any help! SQL 2000 Standard Edition with SP3. The title and document column are both Full text indexed. The problem I'm trying to solve is how to get the below stored procedure to search BOTH columns for the criteria entered. Search Example: "pin*" or "Yello*" Returns 2 r...more >>

What does the status "Notifications Processing" mean in FullTextCatalogs? I have been unable to find any doumentation on this status. ...more >>

Gurus, Here are the things that i am trying to do 1) store word, excel, pdf and ppt files on the sql server 2000 through c# and asp.net 2) retrieve these files and display it to the users through asp.net and c# 3) search for the search text that the user is has give and show him the appro...more >>

When running the following query against MS SQL Server 7.0: SELECT documentitems.manufacturerpartnumber,documentitems.customnumber01,documenthe aders.customnumber01,documentit ems.description,documentheaders.projectno FROM DocumentHeaders INNER JOIN DocumentItems ON DocumentHeaders.ID ...more >>

I've been learning a lot about full text searching over the last few days while working on a large scale project (well, large for me atleast - currently almost 4 million records with near-future expansion to about 10 million). I still have a few unanswered questions though. First, let me give...more >>

i created catalog in my local folder to do full text search.now iam going to deploy our application in the website.so can u let me know how we can deploy the catalog from my local machine to web server. Thanks and Regards, K.Mohan ...more >>

Dear Aall, How can we search for all the key words? Is it possible to write a single query with Freetext or Contains? Example: if I search for 'Microsoft has released a new Operating System' I should get the result which contains all the Key words in the phrase we search. Here in this examp...more >>

As it can take a long time to create the full text index once the database is restored I think it is a good idea to back up the full text catalog. What is the best method for doing do ? ...more >>

Hi, We are using SQL 2000 sp3. We have a Customers table in which the customer's name is FTS indexed.. Since the insertion into the DB is made manually the customers' names are often misspelled or written with small modifications from the already existing names in our DB. The table is using S...more >>

We have a server with 2 drives. Drive 1 has our swap file, operating system and SQL transaction log writing to it. Drive 2 has our SQL database and flat file dumps (db backup) We can't install a 3rd drive pair as there is not physical room in the server. Which would be the better drive to ha...more >>

Is it possible to change that was the SQL breaks text into words. I have data with descriptions of automotive part and accessories that have names like "01-03 toyota acura headlight". So if a user want to search on "01 acura headlight" it can't be found because the "01-03" is treated as one wo...more >>

I have not been using FTS for long, so maybe I am missing an obvious this here... I have a table with titles of products in them. Its about a million rows. If I do: set @arg='("pda") and ("case")' select stockcode, rank, from containstable(product,*,@arg, 1000) order by rank desc and ...more >>

I was just browsing SQL Server blogs appearing in my feeds, and this one struck a note with me because I would kill for BOTH of the features he mentions. http://www.yafla.com/dforbes/categories/SQL/ Sorry for spamming some guy's blog, but if the SQL dev team reads this please take a look at...more >>

Hi all, I am trying to do a partial word search in SQL but it does not look possible with FTS. Can anyone clarify? Specifically, I am searching a 'lastname' field and want to find any partial matches. So that 'tua' and 'stuart' both match the record with a lastname field value of 'stuart'. ...more >>

Hello, I've just started using full-text with SQL server 2000 (its version 8.00.760) . This is for a client, I'm a free-lancer. I got it set up and running and am feeding in records. I want to have it re-index every 5 minutes (I'm adding a batch of 100 new records or so every 5 minutes) The...more >>