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:"екдоты..." (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 >>