I was having a problem creating a fulltextindex on the following table. I have the following table: CREATE TABLE [dbo].[QADocs] ( [fullFileName] [varchar] (100) NULL , [fileNameLong] [varchar] (100) NULL , [fileNameShort] [varchar] (100) NULL , [fileExtension] [varchar] (10) NULL , [...more >>

Hi there, Any news about hit-highlight in sql search? Anyone has a function/sp that can help with outputing better formatted-results to the user? Thanks! ...more >>

Hi there, To ignore noise words errors (i.- Server: Msg 7619, Level 16, State 1, Line 1 Execution of a full-text operation failed. A clause of the query contained only ignored words. ) I've searched and emptied the content (not deleted) from all occurences of the noise.dat file. I resta...more >>

We had a customer request a full text installation after the application of SP4 and the slammer hotfix. It throws an error that refers to a re-installation of SP4, which will not work with any hot fixes applied after the fact. Does anyone have a different route to follow that uninstall t...more >>

Hi all, I know portuguese is not supported by FTS today. So i=B4m trying to 'develop' it by my own. First thing i=20 did was to re-write the stop words listed in noise.dat=20 with noise words in portuguese. So far, so good. Now, where the hell can i find the rules=20 used by the stemming...more >>

I am new to sql server. I have just installed Microsoft CRM which needs Sql Server. It tells me that I need to have Full-Text Indexing running on the database but it is greyed out. The Microsoft Indexing Service is running and I do not know what to do? Any help will be appreciated. Thanks Bri...more >>

Hi, We have a SQL 7 legacy database that has Japanese text in the fields that appears like this in the field ボディ but presents in the right Japanese characters when presented in a web page. We are trying to add new Japanese text to the database, pasting it from an ...more >>

I have a problem in full population for a full text index. When I run the population; these are the results - Population duration : 3-5 seconds. - item count : 0 - catalog size : 0 - unique key count : 1 although I have 7 million of records in that table I need explanation please. Than yo...more >>

Hi! I'm looking for ideas on what would the best approach to design a search system for a RSS feeds. I will have some 50 RSS feeds (all RSS 2.0 compliant) stored locally on the web server. Now I'm wondering what would the best method to allow searching of these RSS files. Since the search will c...more >>

Hi, I dont know if this post has been repeated before. Is there a way to get all the recent search terms passed through Full text search? Thanks, P...more >>

I have SQL Server 2000 running on Windows XP, and want to access the index server on a Windows 2003 server. I use the well known servername.indexname..Scope() to access the remote IS. This actually worked for me for a bit. I'm not sure what happened, but it stopped working and I can't get it to...more >>

I can not get the full text catalog to populate. I have tried it on the most basic datababase and table. The catalog creates, and it says it successfully populates, but yet the item count is 0. I have restored the same DB on a different server, and it works fine. I have tried so many K...more >>

Need to search through a database and remove references to a company from it. Grrr! How can I do this? Do I need to write a client script to load each offending record, or can I do it with SQL? Conceptually I want to do REPLACE IN Resumes TEXT 'Company Name' WITH '' This is a full text...more >>

I am trying to "Define full text indexing" on a table but when it attempts to create the catelog, I get the following error: Execution of the full text operation failed. The directory name is invalid. Any ideas? I check to ensure the directory is correct..... Mike B...more >>

Can anyone explain me how to configure full text to run on a windows 2003 cluster (2 machines 1 sql node)??? ...more >>

I am tasked with designing a procedure that a client could use to move to a different database server wuthout losing their data or full-text index. I am using the KB article Q240867 section labeled "To copy full-text catalogs between instances of SQL Server to the same local drive or path." When ...more >>

I changed the MSSSQL accoutn using EM not Control Panel... Does anyone else know what i can do?...more >>

Hi, I'm getting very frustrated with the usual "A clause of the query contained only ignored words" problem when using fulltext searches. Is there any way at all I can prevent this error from happening? Is it safe to change my noise words file to be empty and force a repop? I really NEED...more >>

Can anyone tell me why this doesnt work: 1- full text service is running under local system account 2- sql server is running under a domain account 3- local admin consists of both (domain admins and system) 4- correct priviledges are given to the folders (sql folders) 5- sql is in CLUSTER (...more >>

I have a project that uses a linked server in SQL Server 2000 to query a local Index Server. This works fine. I've been experimenting with moving the catalog to a remote Index Server and querying it via Index Server running on the SQL Server machine (using the four-part SCOPE syntax). I've fol...more >>

I have asked (and had a reply - thanks!) this question before, but i'm in a hurry and cant seem to find the solution even by googling myself. I have a database which had a FT catalog on E: on one machine and i've moved the database to a machine with only a C: I remember the solution has some...more >>

I have a large full text index (30 millions records) that is populating on a live server (they are just doing without the full text search stuff for now) and the index goes into shutdown mode. What is that???? Last time it did this i stopped and started the mssearch service and it started back...more >>

Hi, I don't want any noise words at all for my current application, so have cleared out the noise.enu file so it is 0 bytes and re-built the catalog I am pretty sure it is working ok because I can search on 'the' and 'of' etc which I couldn't do before. however, if I try to search on a singl...more >>

I am trying to update an ntext field between two servers. The sintax I am using is the following: DECLARE @ploc binary(16) DECLARE @prem binary(16) SELECT @ploc = TEXTPTR(ntext_field) FROM tablename where id = 55298 SELECT @prem = TEXTPTR(ntext_field) FROM SVR.DBNAME.dbo.tablenam...more >>

Hi, using SQL server 2000, I have a ft indexed column that contains the name O'Donnell (for the sake of argument). using CONTAINSTABLE, I would like to match this against any of the following search criteria: 1 O'Donnell 2 ODonnell 3 O Donnell 4 Donnell I have changed th...more >>

In the below FREETEXTTABLE query, I have the SELECT fields indexed in the FT catalog. I should be getting results and I'm not. The problem, as I see it, is that I need to be searching all 3 tables when actually I'm only searching 1 table in this expression: FREETEXTTABLE(ItemStock, *, @SearchCrit...more >>

Using the following query I get my desired results. However, in the resulting recordset, how can I show for example 10 words before and 10 words after the keyword or phrase that was searched upon? If I get 20 resulting records I think it would be easier for the user to decide which they want to ...more >>

We're having some difficulty getting adequate search results. We're trying to search across 3 columns, "author", "title", and "subtitle" (no other columns are part of FT index). The problem relates to searching for an author/title phrase at the same time. Say the user types "chemistry brown" into...more >>

I learned recently that Microsoft has a Most Valuable Professional (MVP) program to recognize, honor and reward people who regularly provide technical support for Microsoft products through discussion groups. For information about the MVP program, see http://www.microsoft.com/presspass/features...more >>

We are still struggling to get stable operation with full text indexing. After a variety of problems that I have posted before, I am trying a smaller table with about 3 million rows, and I'm using incremental builds rather than change tracking. At the end of an incremental population last nig...more >>

Hi all, I'm looking for in-depth information on the search functionality of SharePoint 2003. As it is using the SQL full-text search, I post my question to this newsgroup. The main goal is to figure out how I can add the functionality of rating documents to the SharePoint search, in order t...more >>

I'm trying to do a FREETEXTTABLE search on two columns. I can get it to work correctly with searching only one column. I basically need it to do an OR on the two columns and haven't been able to find anything on that. It seems like I'm limited to finding matches that have it in both columns....more >>

I have SQL Server 7 on an NT server. The catalogue has been working for a long time, however, it stopped and I cannot seem to get it to repopulate. It stopped during an incremental population. I have tried deleting it so I can rebuild it, but whatever I try to do, I get the same message...more >>

This question concerns searching in a windows sharepoint services site. I have posted the question there and have been advised to post it here instead. As WSS uses 100% standard SQL Server 2K full-text search, is it possible to do an exact phrase search? If it is possible, what should be ...more >>

Hi here is a simple question : How to simply create a good search engine with the FULLTEXT functionnality of SQL SERVER? In fact, I have done something.... but , I want that the search look INTO words for exemple, i I search for the word "SOFT", ....the search engine must return MICRO...more >>

With Windows 2000 Server and SQL Server 2000 I have a full text indexed database. I want to be able to search for C# (the content are resumes) but cannot because it is an 'ignored word'. I believe the issue is due to the operating system version of the mssearch component, which explains why...more >>

Is there a way to get additional match information from SQL Server 2000 CONTAINSTABLE? For example: If my text data is: The black bird and the blue bird... 01234567890123456789012678901234 And I search for bird, Can I get results that tell me that 2 occurances were found inside the data a...more >>

I'm using FREETEXTTABLE and would like to use wildcards, but I'm not getting expected results. SET @SearchCriteria = '"*rose*"' The above appears to ignore the wildcard before the text. I also tried the LIKE operator without luck. What's the rules for using wildcards in FREETEXTTABLE? thanks...more >>

I will explain step by step what I have done, hope it will make it easier for the gurus to solve my problem. Requirement: Be able to search PDF files stored in SQL. SQL Server: 2000 (SP3) Window: 2000 Server 1. Installed Acrobat iFilter 5.0 2. Created a table to store PDFs. creat table ...more >>

The following FREETEXTTABLE query works, but I'm getting all rows returned. The highest ranked are at the top like expected, but it's also returning all rows in the Stock table that have no match whatsoever. In my FREETEXT query (bottom), all the results had a match. I don't get the concept of ...more >>

i'm trying do this in sql: the mysql query: "SELECT id FROM browser WHERE '$http_user_agent' REGEXP browser_regexp" where $http_user_agent is a string i.e."mozilla/4.0 (compatible; msie 6.0; windows nt 5.0; .net clr 1.1.4322" and the browser_regexp is column in table "browser" with values "msie...more >>

I have several instances of SQL Server 2000 Personal Edition running on 2000 Pro and XP Pro. Are there any issues with installing Full-Text Search on these machines? Thanks ...more >>

Will the full text catalog break if I delete all the records from a table. I dropped the table and the Full text catalog broke. My assumption is that it is attached to the table and when the table is dropped the catalog is also lost. Is this correct. I need to change all the data in the tab...more >>