OS: Windows XP Pro DB: Sql Server 2000 I set up a full text index on a "searchfield" column on a table. It created and populated just fine with an item count of 1744. Whenever I run a query using contains or containstable or anything like that, it doesn't return any results. I've bee...more >>

I have been having a problem with the microsoft sesarch service failing on boot up. All that I get from the event logs is: Event ID: 7009-"Timeout (30000 milliseconds) waiting for the Microsoft Search Service to connect." and Event ID: 7000-"The Microsoft Search service failed to start due to the...more >>

hello all, here is a newbie's question, pl help me out. i've a bunch of products in a table with productcode containing the string 110. when i execute select distinct productcode from pf_catalogproducts where productcode like '%110%' i get back 50 products but when I execute select d...more >>

Hi, I create FTS catalog and populate it (successfully) but the item count in catalog is 0. No error messages when I run full text search sql statement using(contains) but no result too plz if u can help. regards, Ayman...more >>

Has anyone installed full-text searching after installing SQL server 7.0? Does it stop SQL services?...more >>

Hello, I have a table with roughlly 5,000 records. The table is updated every 10-15 minutes with 50 new records being added, and similiar number of records being dropped. However, I only need ~10% of the records searchable (those who falls between getdate() and getdate()-1). I have two que...more >>

Hi everyone, I have restored in a new istance of SQL (no upgrade) a backup of a database of another istance. Ok... but my full-text has stopped to work! Any full-text query working, but if I try to rebuild a catalog that already exists I get the error: error 7608: An unknown full-text...more >>

How do I do a backup of SQL Server and the Full-Text Search catalog that it references? ...more >>

Error: 7619, Severity: 16, State: 1 Execution of a full-text operation failed. No such interface supported MSSEARCH and serveragent are both started.... ...more >>

Hello there I have database designed on sql server The application is VB or Access ADO. On the application i have rich text control. On the rich text control i type charecters or i Load RTF file. If I store the Object.Text on nvarchar the letters are stored but none of the special de...more >>

Afternoon folks Ive just done an in place upgrade from sql7 > 2000 ( on w2k server sp4) and have noticed there are no options for creating catalogs as the option is greyed out I have installed the component after upgrading as per guide, installed sp3a and booted etc but still no luck --- any ...more >>

Hi! I'm trying to fulltext search image field in SQL database that contains various documents, most of them Word documents. The documents are placed in the database by an ASP.NET application. The data table also contains varchar field with fileextension of the original document file (".doc...more >>

Hi All, Our web application log file reports the following error message when an end-user trys to search on a column that has a full-text indexing: "[ERROR] archives.display_results(Execute new Query - SMTP) : java.sql.SQLException: [Mitra2000]Search on full- text catalog 'CAT_Mime_Cont...more >>

I have a copy of MSSQL 2000 running in a shared hosting environment with 286 active databases. It has recently come to our attention that the "Full-Text Indexing..." menu option has become unavailable (grayed out) to anyone who tries to access this option via Enterprise Manager, this of co...more >>

I'm looking for thoughts/advice on how to build the fastest search + (paged) results-page in an .NET + SQL Server 2000 environment. I hope this is the proper group for this, otherwise i appologize for the spam. I have one table with around 100.000 records containing some text fields. What i ne...more >>

Hi All, I have Unicode Arabic HTML data in an Image column (PageText) and (htm) in PageFormat column and Full Population too. But this query has no result. SELECT * FROM tblBookPages WHERE CONTAINS(PageText, ' "any arabic word" ') Please help me. My Server Configuration **************...more >>

Hello, I have been asked to "try" to quantify the impact of server performance when enabling the FT-Engine. I plan on indexing 2 columns in two different table the columns are each defined as Varchar(255). I plan on doing an incremental update in the evening. What if any would be the impa...more >>

Hello, I tried Hilary's advice on clearing the noise words entirely (see below) and still receiving errors as "(Syntax error or access violation)<P> [Microsoft][ODBC SQL Server Driver][SQL Server]Execution of a full-text operation failed. A clause of the query contained only ignored words." ...more >>

i need to convert this mySQL statement to work in MS SQL Server: SELECT MATCH(myTextField) AGAINST('searchstring') AS MatchValue FROM myTable WHERE MATCH(myTextField) AGAINST ('searchstring') ORDER BY MatchValue DESC the results from this query produce a decimal value, assuming its the ...more >>

Hi Folks, If I try a FTS with searchStrings that are in different tables I get the Error-Message 7615 SQL ERROR, A CONTAINS or FREETEXT predicate can only operate on one table SELECT DISTINCT cs.id FROM context_gst cg, context_sst cs WHERE cg.id=cs.id AND CONTAINS(*,'"first*" AND "second...more >>

Thanks John for the help with my previous problem Trying to perform a search with FREETEXT(content, '"#3"') and receiving the following error. Microsoft OLE DB Provider for ODBC Drivers error '80040e14' [Microsoft][ODBC SQL Server Driver][SQL Server]Search on full-text catalog 'content_content...more >>

Hi all I'd like to get all the information of table1 in which colum1 contains this characters : select * from table1 where colum1 like %per% but using Full Text Search this is the nearest query i've found: select * from table1 where contains(colum1,"per*") Is there any way better?...more >>

I am trying to get a couple of things straight before implementing anything. Any comments would be appreciated. It is my understanding that for performance it is better to save documents like PDFs outside the SQL Database (I'm using MS SQL Server 2000) and only save the path that points to th...more >>

I need to expand the capabilities of SQL Server 2000, I need that one query return more hits. The text to search is in Spanish and the SQL Server Full-Text query is configured in Spanish too. Example: I a search for the singular word "restaurante", and it plural form "restaurantes" the query giv...more >>

Hi! Everybody, I found that full text search cannot be executed when SQL Server is started up by domain user. I have already added the user to server's local administrators group and also added authority to SQL server. Full text search is working fine when SQL Server is started up by Local ...more >>

Hey all, Having a slight bit of trouble with a Free Text Query here. We have a large database containing records that have Business Names in them. It was brought to our attention when a user attempted to search on "D & M Farms". This is the name of the business, and it is also how the data is...more >>

Help: FullText catalog wasn't populating and believe we were able to tie it to a failover. Followed steps listed in kb240867. now the ms search resource will not come on line through cluster administrator. Here is what the event log shows: The Gatherer property mapping file cannot be ...more >>

Microsoft OLE DB Provider for ODBC Drivers error '80040e14' [Microsoft][ODBC SQL Server Driver][SQL Server]Execution of a full-text operation failed. A clause of the query contained only ignored words. /v2/includes/functions.asp, line 465 ...more >>

Hi, My platform is SQL2000 Server and Windows 2000 Server. I am using JSP to retrieve my documents. My FTS appears to be working fine. I am storing Word documents (.doc) extension on image column. However, I would like to retrieve the word documents content as html document. Is there a w...more >>

I'm trying to write a sql install script so a client can just execute the script in query analyzer and it will create all the tables, views, fts catalog, etc. I've got everything working fine except I don't know how to make it create a population schedule for the fts catalog. Is this possible ...more >>

Hi, I am trying to eek out some performance on my fulltext queries and have picked up some useful tips from this forum. Currently i'm focusing my attention on attempting to reduce the size of the fulltext catalogs. I have 2 catalogs A) 300MB, 214k rows, approx 2k queries per day B) 40MB, 1...more >>

I made a mistake in my SQL server: "...Group SA..." should be "Group: A" in one of the field. There are hundreds of records need to be modified. I'm new to SQL and I tried this: USE databasename SELECT REPLACE('Group SA', 'p SA','p: SA') GO But it didn't work at all. Could anyone help m...more >>

Hi, I would like to use SQL Server 2000 Full-text indexing on various file extension types such as XLS, DOC, HTM and PDF, stored in a table. I have done the following: 1. Created a table as the following: CREATE TABLE [dbo].[WPFTImages] ( [WPFTImageId] [int] IDENTITY (1, 1) NOT FOR R...more >>

hi all i ma developing on an sql 2000 / win 2000 platform. i have built a table which contains a data in a unicode format..ie:"&#1077;&#1082;&#1076;&#1086;&#1090;&#1099;..." (this specific data is in russian). i have full text indexed the table (Neutral "Language for Word Breaker"). i have...more >>

Hello All, I've come across the need to backup and restore a DB w/ FT catalog to another server. I would not have a problem running a full population, as it is relatively small (takes < 1 hr to populate). The restored DB of course contains the old FT Catalog entry with the old path. I've en...more >>

Our SQLServer version is English, but we need to search in Spanish using Full-Text search. The problem is that it don't have Spanish support. Anyone knows if the Spanish support for the Ful-Text is available in Microsoft Downloads??? ...more >>

SQL Server 2000 on Windows 2000 and XP Pro I've created a full text index successfully. And I've confirmed in the application event log that MSSearch ran successfully. I get search results on all fields except the ntext and the image field. I don't get an error. I just get 0 results. These ...more >>

I want to use AND/OR/NOT operators in a text query to search my full text indexed table... I have a search set up now that will not use thoes operators.. this is the query I am useing for it... ftSearch = "SELECT TOP " & Me.cboResultsReturned.SelectedValue & " FT_SEARCH.[KEY], FT_SEARCH.RANK, ...more >>

Hello All, I've been asked to improve upon a search query and am wondering if Full Text indexing is a good solution for this. Basically what we have is a contact table that has a related Skills and Industry tables. To further complicate things I would then need to filter down by country. ...more >>

Hi all, I'm a newbie here. I need to store an xml content into SQL Server. Originally, I was planning on storing it as a TEXT data type. However, from the little research I've done, it seems that you can only apply Filtering on IMAGE data type. Is this correct? What would be the best way to store...more >>

I am storing massive amounts of image data in my SQL Server 2000 database. As part of this storage, I have to execute loads which contain millions of records to be inserted. The current process takes the file path (text file) and streams the object into my SQL Server table as binar...more >>

Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Personal Edition on Windows NT 5.0 (Build 2195: Service Pack 4) Running on Microsoft 2000 Server. I have a table that has an image col and a Type col CHAR(3) I am...more >>

Can anyone help me with the following problem: I have a database with a column containing long text-values. Inside theese textvalues there are som url's that I need to change, or atleast part of them. What I need is a SQL query which updates only part of the text-streng. The url's point to ...more >>

With a Full Text SQL query using a FREETEXTTABLE is there a means to know "where" and "how many" occurences of the search argument satisfied the SQL query ? I want to highlight the various hits with some form of a visual representation. Thanks ...more >>

Is Full-Text integrated with MSDE? If it's certain , how can I know it? and to activate it? Maybe with OSQL? Thanks for de answer. Regards.I "Cuanto más cerca de la humildad, más cerca se estará de la grandeza" R. Tagore...more >>

Hi , I am having table test_a Table Name: test_a Fields are: ID Int 4 - Primary Key Name nvarchar 100 Document Image 16 Null Full Text Indexing is done on Name field but I want to retrive output on D...more >>

I installed full text search on SQL Server 2000 developer edition, but still i cannot see an icon for the Full-Text catalog, and the full-text search icon on the right click of a table is not enabled. This has happened twice with me on two different machines. Any solutions. Thanks Sanchit...more >>

I have a list of keywords separated by comma in ntext column. I'm wondering if this is a typical way to stored keywords. Or should I remove all the comma separating keywords and make the whole text looks like a single block of text? Which is preferrable for performance? I'm using CONTAINSTABLE() ...more >>