Greetings! I have a requirement to set up several full-text indexes on our SQL Server 2000 database. My problem/question is how to get the results to show up in a form or datasheet in our MS Access XP front end? I'm planning to be able to allow the user to enter search criteria via an Acc...more >>

I have a front-end search set up that takes the users input and runs a stored procedure that uses FREETEXTTABLE to get the results. I want it so that when a user types in a search that has words grouped together inside quotes (i.e. "sql server") it does an AND instead of an OR. I know that CON...more >>

Dear Friends, When deploying the application I send a back up of the data base to be restored on clients place. there is a table in the database which a has FullText Index associated with it. However since it is in a different machince the client server cannot recognise the Full-Text catelog....more >>

Some people are saying that the only way to do a accent insensitive full text search under SQL 200 is to replace mssearch with the version that comes with Share Point Server. Is this true or is ther another way? If it is true how are you supposed to send this to clients as not everyone has ...more >>

I am running into some wired problem with nvarchar(4000). When I insert the chinese characters, the text got cut off. The following two sections shows what happen, the first chinese section is what is ended up in the database, the second section (separate by "--------------------") show the com...more >>

Dear Friends, When I tried to start Micosfot Search Service on Windows 2000 Server with SQL server, the following message was obtained. "Could not start Microsoft Search Service on Local Computer. Error 3: The system canot find the path specified." When I tried to apply SQL2kSP3 t...more >>

I am running on Sql Server 2000. This was set up a couple of weeks ago and ran fine. I came in today and was looking at some of my asp.net pages and started to get the error: Execution of a full-text operation failed. The catalog does not exist or is currently unavailable I tried just ...more >>

Hi I would like to know if solution a is faster than b: a) Fulltext index on theese columns x nvarchar(250), y nvarchar(250), z nvarhar(4000) b) Fulltext index on columns x, y and splitting up z to a relational table with nvarchar(200) bits of the existing nvarchar(4000) field. The ro...more >>

I have a customer that is complaining of poor performance when doing searches against the FTS catalog during the day. I believe what is happening is that the indexing process is taking place at the same time as their searches. select @@version ------------------- Microsoft SQL Server 2000...more >>

In Windows Sharepoint, I can't get the catalogs to build either manually or by using the Sharepoint Central admin console. They have between 1-8 items, and are never larger than 1 mb, even though the content is > 3 GB! This is on a SQL 2000 Ent. running on a 2-node A-A cluster; could that be ...more >>

I have FTS enabled on a number of columns on a SQL 7 database table, and today for the first time I've had a strange result for a search term. The term does not exist, and has never existed, in the column I'm querying, and yet using CONTAINS(QuickSearch,'"0130606219"') as the only WHERE clause...more >>

Hi Guys SQL Server 2000 SP3 (WIN NT/2000/XP) Can somebody please explain how I can overcome the following (what looks to be) limitation in SQL Server's FullText capabilities? Consider the following query (table defs at bottom of post): select * from a left outer join b on b.b_id...more >>

Hi All, I am trying to implement a FullText search for a table which contains translations for many different languages. However, different languages utilized different word breaker for the FullText search to work properly for that language but I can only assign a single word breaker to a ...more >>

I have the following: SELECT jobTitle from position where FreeText(jobDescription,'sales and ccna') order by JobTitle DESC This gives me 11 hits If change change the FreeText clause to: FreeText(jobDescription,'sales') I get the same 11 hits. But if I change it to: ...more >>

Is it possible to create a second FT-INDEX for the same table? I want to index different fields in each one to use it in different areas. Alternatively, is it possible to do a FT search on MULTIPLE fields in an Index? I know that the FREETEXTTABLE can only do it on either one or all inde...more >>

Hi, I am using SQL Server 2000 on Windows 2000 server. Here is my problem: @String = 'word1word2word3word4word5' - This value is passed to Stored Procedure from the script. Column1 in a table1 has many rows with "words" . One row in this column1 will have 'word3'. Notice that this 'word3' i...more >>

I want to use SQL 2005 FT to search on web page I crawled from web. The page can be Chinese, English or Chinese/English(Chinese article with English phrase in it). First question is that what language word breaker I should choose. Does Chinese word breaker make its English content hard to sea...more >>

Hi, I have problem with Contains command . I've made index on FName column of my database which is nvarchar(100). When I call contains command to search for english strings , it works very well .But when I search for unicode strings ( I use farsi strings and insert them in unicode ), someti...more >>

Hello. I'm trying to create a search engine for my Web Site using Indexing Service. The content is stored in text files in UTF8 Encoding (arabic text). The search utility works well on my local server but it throws an exception online: the query return only ignored words. Every file contains t...more >>

Hello, Could i get information on how chinese charecters can me made to display in SQL QueryAnalyser.I have tried installing language packages. Thanks in Advance:) Sowmya -- Message posted via http://www.sqlmonster.com...more >>

I have a customer who insists on being able to search products via substrings in the product description. I do a search in the style of: select * from products where description like '%whatever%' With only 200.000 records in the table and a resultset of 50 it still takes 3-10 seconds, which is...more >>

I've got a table (dexIndex) with 9 million rows in it. It's got an identity column (index_id) and a column that's full-text indexed (insureds_name) and a column that I want to filter on (agency_number). When I query like this: select * from decIndex where agency_number = '0349323' and con...more >>

My understanding is that there is only a wildcard suffix to use when searching Full-Text Search items. ex: john* This will return john, johnny, johnson, ... Is there a prefix wildcard like *son to search for johnson? Users of my FTS application are used to conventional searches where a l...more >>

I want to get a estimate of size of the catalog based on the size of the data it is indexing. for example, for 10G of Table size(table contains just a column of varchar(255)), what is the size of its catalog? I know that it depends on its content, but just want to get a idea of how big cata...more >>

I want to do Full text search exclusively using SQL 2005. Is there a way to focus the SQL server to load the catelog into the system memory and stay there? Since I want to make the search fastest as possible, everything else can be slow. Thanks --Xin Chen ...more >>

I have a table called bookdata with 20 fields mixed of varchar and text. Can some one post the syntax or point me to a direct online reference to show me how to do this? Thanks ...more >>

Hi, I have problem with Contains command . I've made index on FName column of my database which is nvarchar(100). When I call contains command to search for english strings , it works very well .But when I search for unicode strings ( I use farsi strings and insert them in unicode ), someti...more >>

What is the sql syntax for creating a full text index on a table? I have a table called bookdata with 20 some fields I would like to index. Then how do you construct the queries? Is it something like 'where contains (colname, 'itemtofind')? ...more >>

Hello! My client has a need to be able to store Japanese characters in their PeopleSoft database. So we need to change the character set from from Latin1_General (1252) to Japanese character set (932) on SQL Server 2000 Enterprise. I have 2 questions: 1) I would like to know if in SQL Server,...more >>

Hi, I have an app that does case-insensitive, accent-insensitive searches using sql server fulltext engine. It deals only with western-european lanaguages (mostly just English and French). The tables are stored in Latin1 General CP1. However, I also need to process the search results in ...more >>

After creating several full-text indexes from tables to a Full-text Catalog, I can see the names of the tables for those indexes. However, when double-clicking the Full-text Catalog, the the item count was still zero. I am sure the Microsoft Search Service started and there was a Full-Text S...more >>

Hi John/all , We faced the same problem as like Thomas. (see below the next or last question..) But we got a different error number, when we start the Search service. Error is : " The Gatherer property mapping file cannot be opened. Error: 80070003. The default values are being used. You ...more >>