I see sqlserver2005 has no many languages which were announced. For example I need arabic as the language for indexing and search. I dont see it in the language list.No wordbreaker. Any ideas? ...more >>

I've created a couple of full-text indexes using the FT wizards and/or sample code from BOL. Everything appears to be correct and I've run a full population on them without getting any errors. However, when I run my queries to test the results I get no rows returned. When I look at the pr...more >>

I have a question about SQL Server 2000 Full Text Index. I want to create a catalog in a field (varchar(255)), but I´m with 2 problems: 1. The characters of this field can have accent. But when I do a search I want to see the rows with and without the accent. For example: SELECT N...more >>

I have number of catalogs on my server. when i am clicking on the full text catalogs section on the enterprise manager the enterprise manager is stucked and i cant see any catalogs. anyone knows what is the problem? thanks!...more >>

I am trying to set up full-text indexing on my SQL Server 2000 instance running on WIndows 2000 Server. Every time I try to create a FT catalog, I get the following message: "The microsoft search service cannot be administered under the present user account." I have read other postings tha...more >>

Hello, I recently posted this question on the WSS group, and it was recommended that we post the question here, since WSS uses the SQL Server F/T engine. We have WSS 2003 running on a SQL Server 2000. WSS. We tested F/T searches and the documents that we expect should be coming at the to...more >>

Hi, We're running a Windows 2000/2003 network. On Servers running Windows 2003 with or without SP1 and SQL Server 2000 SP3a or 4, we cannot create any full Text Search Catalogs. Whatever login we try to use, if we try to create a new catalog, from Enterprise Manager, we get a dialog box...more >>

Hello , Is there a way to implement wildcard search like using LIKE operator to implement in FullText Search using FREETEXT or CONTAINS? For example Giving a key word, 'Mexico' should fetch the records which contains 'Mexicocity' Thanks in advance. Regards Sathian ...more >>

Hello! I want to information about INDEXING? Why we creat index and how to creat and where we can manage index? In SQL 2000 EM where we can see old indexes ? regards, Henrik...more >>

Hi This may be an ancient query -but I have not found answers searching across MS's WWW site or the wider internet. I have SQL 7sp4 + combined security update for sql7sp4 I have recently tried to enable full text indexing, so went back to the SQL 7 CD and added the component. ...more >>

Hello just a little question : in full text search, in SQL Server 2000, how to enable accent-insentive? for exemple : if I seize "tele", I want to have results with "télé", "tele", "téle" and "telé" thanks for your answer! a+ syl ...more >>

Hi - I did the following SQL Query. set @sql = @sql + 'select distinct s.PrimaryKey, indx.rank, d.documenttype_id, d.publish_date, d.Document_ID, d.Document_name, d.Description, d.create_date ,isnull(f.mimetype,'''') as [mimetype] ,isnull(f.filesize,0) as [filesize] --,db...more >>

Hey all, I'm using full text indexing for keyword search capabilities for one of our clients'. We needed to provide boolean search capability and hence I chose containstable instead of freetext. The stored proc works fine except that for specific keywords the client expects certain document...more >>

I have a query SELECT DISTINCT Top 400 PFSchemaInstance_ID, 0 Rank, 0 CriteriaCount, FromDate, pfSchemaInstance_ID FROM PFLightningSearch_PersonProfileImpulse_Publish L WHERE CONTAINS (Text, '"s*"') Order by FromDate desc, pfSchemaInstance_ID desc And I know the Text column contains st...more >>

I have a table with 2 FTI columns, but my query results seems strange. If I run this query: AND CONTAINS( J.*, '"DEVELOPMENT" AND "MARKETING" AND "FIFE"' ) it returns no rows. AND CONTAINS( J.*, '"DEVELOPMENT" AND "MARKETING"' ) this returns one row as both words are in the same FT...more >>

H there, We have a query that is taking too long to run, which uses Full Text (MSSQL2000). The query below, when using this clause takes between 11 seconds and 10 minutes! QA thnks that the full text search will cost 70% of the query cost. CONTAINS( Article_text, '("Food" AND "Supermark...more >>

Hi Can anyone please help??? We wish to build new features for our db and I need to perform FTS using all queryied words against a number of columns (spanning in 2 tables), but I cannot see how this could be done. That is every word needs to be checked against every field because we wil...more >>

The presence of a single noise word is causing query to fail with this error: "Execution of a full-text operation failed. A clause of the query contained only ignored words." But the full text clause contains three words and only one of them is a noise word. Please see below. Is this a known p...more >>

I have WSS set up to use the SQL full text search, but it wasn't returning full results (though it will return some.) When I tried the search against the table directly, it still only returned 2 instances of the 5 actual occourences of the word. Nothing special, just searching for a simple t...more >>

Hi, I've been googled and haven't found any soloution yet. I'm getting the following error while doing a CONTAINS query on a fulltext catalog. Server: Msg 7342, Level 16, State 1, Line 1 Unexpected NULL value returned for column '[TextData].KEY' from the OLE DB provider 'Full-text Search E...more >>

I got a single SP that searches the indexed fields. But i am only able to use contains(name, @key) property of the indexed fields. @key is the the keywords of the user that he has written. This is insufficient in most cases. For example if user searches a text like this: "ABC CDE"+FGH ...more >>

Hi all,I posted this problem already in Windows Small Business Server, but the guru's overthere, redirected me to this newsgroup. I have installed SBS2K3 premium SP1 with SQL2000 Sp3a (no ISA). While installing SQL2000 I filled in "Full Text Search" and later I configured in Central Administ...more >>

Hi, Using SQL Server 2000 on Windows 2000 Server, i'm working on a 2 milion rows database, in one table. The data are document and the column of my table are "authors", "organisation", "title","abstract" (these four ones are fulltext indexed) and other column with references number. A w...more >>

John Kane recently provided this response to a question of using a pattern match in FTS. John Kane 3/16/2005 6:27 PM PST From Discussion Group: sqlserver.programming Subject: Re: CONTAINS to behave as LIKE %abc% Date: 3/16/2005 6:27 PM PST ...more >>

I had a table that was terribly in need of normalisation that I have now split into two tables. The table contains three "similar" fields that I were previously indexed using a full-text query. I now need to do the query twice as subqueries, UNION the results, then order by the calculated ra...more >>

I setup log shipping on my production server which is a part of Replication and went ahead and created a report server using log Shipping however my Report server is missing Full Text and it don't allow me to create it saying it is read only database. I am running SQL server 2000 with servi...more >>

We rebuilt a catalog this weekend after upgrading to Adobe iFilter version 6. Have attempted the rebuild twice, both times the result has been that all rows are indexed, but the population never 'ends'. The status remains at '1 - Full Population in Progress'. The item count indicates 74,926 -...more >>

Are full-text indexes supported in MSDE? -- Richard...more >>

I have a fulltext catalog called JobDescriptions (with an "s") and I have multiple columns in this catalog (JobTitle and JobDescription mainly). I need to be able to search both columns for the keywords. At the moment I am just looking in the JobDescription column, so it doesn't look at th...more >>

I'm testing now the SQL 2005 Thesaurus capabilities. It seems that the product came with empty Thesaurus and the only way to make it work is by define the Thesaurus in the XML files. Is the final release of the product will be also empty? Regards, Benny ...more >>