Hi everyone, Got a question for you. Which would be faster: a. Joining 2 separate tables each with a full text index on the applicable fields or b. Joining 2 separate tables - 1 of which has a FTI on the applicable field and the other table has a non-clustered index on the applicabl...more >>

I just created a catalog in pubs includes table 'emplyee'. How do I know the indexing population is finshed? ...more >>

Do I need to download SQL Server 2000 service pack to get the full-text search working ? I am using Developer edition. ...more >>

I got SQL 2000 Developer edition installed on both Win2003 and WinXP. However, by going into EM and created a full-text catalog using Pubs database, I can only define the name of the catalog but there is no table table for me to include the tables and the column, any idea? ...more >>

I cannot get the catalog running and read the knowledge base : ArticleID -317746 http://support.microsoft.com/kb/317746/en-us So I issued the command said in the article against the master db in QA. Then tested with select fname, lname from employee where contains (fname, 'Gary') How...more >>

Hi! I tried to use change tracking (with background or update index options) and incremental index. Change tracking is very fast!! Better then incremental function. But my query are very slow now, time to make a query is doubled! Can you help me to improve this behaviour? Thanks! ...more >>

I have created a file system catalog using Windows Indexing Service and also a pub database catalog inside SQL Server 2000. Can I use do a full-text search inside SQL Server to search both catalog? ...more >>

Any RTF filter can I download from ? ...more >>

I cannot make the catalog active. I tried both using T-SQL and inside EM in SQL 2000 but the status is still idle. Any rules I need to stick to? eg. what user login, authentication mode..etc ...more >>

Hello all, I have a SQL Code to retreive messages from a server that have been posted in the last 7 days. See below. SELECT TOP 100 PERCENT Name, Subject, [Date], Message, messageID FROM dbo.Messages WHERE ([Date] > GETDATE() - 7) ORDER BY messageID DESC I wish to add ...more >>

Hi! I need a simple information. I read into msdn that incremental population requires a timestamp column on the table full-text indexed. Well, I have. So if I start sp_fulltext_catalog 'Desc_FT', 'start_incremental' command, how can I be sure that I'm performing an incremental population...more >>

I posted this message some time ago on microsoft.public.sqlserver.programming but got no replies. Today I found this group so maybe I'll have better luck :) I have a table with a full-text index on a given column. If I run the following: declare @s varchar(100) select @s = 'fast' select...more >>

Hi! I need the an explanation. I've created a full-text index on a table TABLEA and on column COLUMNA of TABLEA. If I perform a simple SELECT with LIKE operator as: SELECT COLUMNA FROM TABLEA WHERE COLUMNA LIKE '%sample%' I'm using the full-text index or the search will work as no full-t...more >>

Is it possible to use SQL Server 2005's Full-Text Search feature and have it parse data that is contained in files which are stored on disk? We have an application that stores several useful pieces of information about a large list of documents in a database table. The documents themselv...more >>

Hi there, We've got an ads website with about 170.000 ads divided in categories and subcategories. eg. Ford Taunus, ... = 3-5 (on wheels - cars) Trek mountain bike, ... = 3-19 (on wheels - bycicles) etc. I've got a search query in which the webuser can choose ... 1) to search by ...more >>

Bit of a teaser how can you achieve this. Assume a search criteria i.e SQL AND Server I want to not return the top 5 records but a random 5 records. You can add anything to the indexed column and you can add anything to the search, but the random results need to be out of the full results s...more >>

We tried to create a full-text index on one of our DB tables, and have run into a number of performance issues with CHANGE_TRACKING AUTO that forced us to turn off the FT indexing. Here's a detailed description of our configuration, steps taken, issues and questions. Any help in this regard will...more >>

I've got a search page where a user can input a number of different search criteria such as location, job type, keywords, pay amount, etc. I've got one table that holds all of the data that is being freetext searched so that we don't have to do joins. That has helped speed things up, but I had ...more >>

Hi. I would like to start population of Full Text Index from my stored procedure. In SQL Books Online I found this: The FullTextPopulation method starts or stops Microsoft Search full-text table population, building the index supporting full-text queries on data maintained by Microsoft=AE SQL...more >>

Hi, I'm having problems with FTS and the Thesaurus (US-ENG) on SQL 2005. I want to add a simple replacement value - "admin" = "administration" to my thesaurus. Here's my thesaurus file: <XML ID="Microsoft Search Thesaurus"> <thesaurus xmlns="x-schema:tsSchema.xml"> <diacritics...more >>

Hi, I know that we can know the population status with using cscript gthrlog.vbs <file name> but do you have any monitor script or job summary status about this..? We need to proactive know about our population status.. what is your practice to monitor on this? --soonyu...more >>

I have one table with fulltext search funtion enable. And table have 5 column. question : If we only use on column for full-text search, one of key, one for timestamp... reduce of other 2 column which don't need will help of full population / incremental population? --soonyu...more >>

we have table with full population and incremental population the table have a timestamp column full population took around 1 and half day to complete while incremental population take around 10 hours to complete my question is if i add secondary index in timestamp.. will this improve inc...more >>

Hi everyone, We have a number of similarly structured tables called collections and we need to do a full text search on all of the tables in any full text search query. The text columns can be fixed for simplicity but in reality the structure of each table may vary. Our interest is doing...more >>

Hello, I develop an ASP.NET application which is connected to SQL 2005. I encounter a problem, it is that always the first request that I sending on fields contained in a full-text index is extremely slow and always exceed the 30 seconds; the requests which follow are very fast (1 ...more >>

Anyone knows where can download/buy a iFilter for pdf ? ...more >>

I have created 2 catalog for searching, however, I noticed these 2 catalog in EM the status is Idle. I tried to Rebuild and Start Full Population but the status is still Idle. My SQL version is 2000 Developer. I checked the MSSearch Service is started. Any idea? ...more >>

I copied the database from production and loaded it to staging server. I, then rebuild the catalog. Population of indexes went fine, however, when I run a query in staging, I get fewer rows as compared to the result from the production. The difference is relatively big, staging returns 139 rows ...more >>

Hilary, thanks, you put me on the right track. Here's what i needed to do. 1) take the value 0xABA665FBE7A2314DAA6943FB87DFAAFE 2) remove the hex designation and put in the dashes ABA665FB-E7A2-314D-AA69-43FB87DFAAFE 3) reverse the first three parts: select * from [file] where file_...more >>

I was wondering if anyone knew of a way to chase down the actual row that generated the error in the full-text log based on the full-text key value that is provided within the error itself, or perhaps there is some other way to find the rows that were not indexed successfully? For example, ...more >>

Probably a very easy question... A user logged into SQL using Windows Authentication can not perform any indexing operations on a db that he has db_owner permissions on. What other rights are necessary for him to have access to the Full-Text Index Table menu? Thanks!...more >>

I've seen a couple of posts with the similar problem, but I could not find the answer. I have 3 servers, all running Windows 2003 Server: - APP (application server) - DB (database server) - FILES (file server) FILES contains an Indexing Server's catalog CAT to index local files... DB co...more >>

Anyone knows where can I find more info on setting up and configuration of Full-Text searching in EM and Query Analyser? The reason I ask for material is I used EM and also QA to create catalog and added tables and columns. But cannot get it work - item count is 0, it is always idle and the CO...more >>

Hi I have a full text index on a table on a few columns including a text data type field, and I'm searching for JN00001 which I know is in the text column that is indexed by the full text index, however the result is not being returned. Is this an issue related to noise words, or why would ...more >>

Does anyone know how to concatenate text to an ntext field when the "text in row" option is enabled? ...more >>

I have created a Full-Text Catalog in Pubs include table authors.au_lname and au_fname in EM. I scheduled the table and catalog population an hour ago(it showed the Last Population Date), however, in EM I noticed the status of the catalog is Idle and the Item count is 0 on the Status tab. And on...more >>

Hello all !! I installed my sps2003/ wss2003 SP2 with sql server 2005. I did few test of full text search and saw performances are very poor. i use sql server 2005 x64 SP1 with windows 2003 x64, i did an "optimisation" of my index file (from enterprise manager) perfomances has been a little ...more >>

I'm searching a database of art information and have created a full-text index on a single table (tblText) that brings together all of the searchable text fields; the table has about 160,000 rows. The web page for full-text searching is generalized so that queries of almost any complexity can...more >>

Hope someone can answer my question: On a aspx page, when I click a "Edit" botton and the page does not fresh, what would be the causes? The harddrive that hosts the SQL Transaction Log Back Up is 99% full, does it matter to the functioning of the aspx page?? Thanks, Frank...more >>

hi all, lets say a user can enter 1 of the following combinations into a search query: "starbucks" "starbucks, San Francisco" "starbucks, USA" "starbucks, San Francisco, USA" "starbucks, San Francisco, California" "starbucks, San Francisco, California, USA" my fulltext database has th...more >>

L.S. While running a full population on a full-text index the following message keeps coming almost every second in the Event Log: Event Type: Error Event Source: MSFTESQL$SQLEXPRESS Event Category: MSFTESQL Service Event ID: 1053 Date: 5/9/2006 Time: 10:44:51 AM User: N/A Computer:...more >>

We are taking a web app that has used index server for the last 3 or 4 years and splitting it. One client will own a version and another client will retain ownership of their copy. In setting up the new clients copy, we have been discussing the option of using FTS in sql 2005. We used it in s...more >>

Hi everyone, You know the way SQL Server 2000 supports prefix term searchs in its full text indexing technology. For example: SELECT FirstName, LastName FROM Employees WHERE CONTAINS(*, 'grad*') But is unable to do somethign like: SELECT FirstName, LastName FROM Employees WHERE ...more >>

I am using Full text search. Problem is if some one enters some abbreviations even then i want the results to come back. For example if some one enters MN then it should bring records which contain MN or Minnesots. SOX then it should bring records which contain Sarbaens oxley or SOX FTS shoul...more >>

Howdy, I just upgraded my Sharepoint instance to Sql 2000 SP4. The full text indexing option is grayed out in the menu. Also SQL Agent won't start, if these are the same issue? Any guidance for getting the full-text indexing running? Thanks!! David Lozzi ...more >>

hello, In a SQL2005 database, i have BINARY/IMAGE fields with files compressed with SharpZipLib, any idea for indexing file content ? maybe writing a custom IFilter ? Thank you for any help you can provide. Frédérick Jacquet ...more >>

Hi, We have a table with 2.5 million rows with a xml data field and has a full text index defined on it. We started populating the full text index about 24 hours back and it is still going. Just to check whether it is indeed populating, we tried some queries with the "contains" clause. If I d...more >>

Here's the full text... One or more documents stored in image columns with extension '.rtf' did not get full-text indexed because loading the filter failed with error '0x80070026'. Note: These documents will not be passed to MSSearch for indexing, and therefore this failure will not be...more >>

Hi everyone, Got a weird one here. Hope that you can help me please. From inside SQL Server 2005 we copied a database from a SQL server 2000 box on our network to the 2005 box. This database has about 1.34M records and had a full text index associated with it. It w...more >>

Hi, I have FTS set up on a table and have about 4 columns that are being = indexed. I just tried to use a Contains query where the words I'm searching on = scattered among all the columns, but no one column has all the words in = my query. I'm getting no results on the query, but as far ...more >>