Hello, All. I need to do queries agains full-text catalogs, but I need that be performed using a "sounds-like" criteria. Is the full-text in SQL Server 2005 able to do that kind of query? Cesar ...more >>

I am developing a custom library for WordBreaking and Stemming using Microsoft's IWordBreaker, IWordSink, IWordFormSink, IStemmer, and IPhraseSink interfaces. I am reasonably certain my code works, but I can't verify the IPhraseSink implementation. I feed my library bits of text that just r...more >>

I have seen multiple posts that state a where clause can help filter a full-text search to ensure no full-text records are searched. What I understand when showing "set statistics io on" -- the worktable is what the FTE uses to search for the CONTAINS. Whether I have a filter (say, on date) ...more >>

Hello, I have installed SQL Server 2005 Express Edition with Advanced Services. The problem is that I see no full text search service on my computer. Please help /RAM/ ...more >>

Hi, when triying to reindex a full text catalog of 25 million rows, the process hangs when reaching the row 7 to 12 million, after 12 hours of runing. its a 4cpu and 4gb server it has 30gb of free disk space. some of the errors are this.... Eventid: 3010 The transaction cannot be appen...more >>

Hi, I would like to help me to restore the FTS database in another machine. The problem is that in the main server the drive letter is different than in the one where I want to restore, in the production(main) server drive in M, in the test server I can put it in D, for instance. Can you plea...more >>

I have a table with 1,500,000 name and first name I use Full text search on name and first name when I use a contains expression like select ... from table1 where contains( name,'abc') the query take 45 secs immediatly after this test I search for the same or another name and the query t...more >>

Has anyone played with the <diacritics> or <diacritics_sensitive> tag in the thesaurus for FTS? If so, have you actually gotten it to affect your results? It doesn't matter what I change it to, in testing it appears to be over-ruled by the FT Catalog accent sensitivity setting. ...more >>

Quick question. The diacritics_sensitive tag of the thesaurus XML files, should it be: #1) <diacritics_sensitive>0</diacritics_sensitive> Or: #2) <diacritics = false/> Or: #3) <diacritics_sensitive = false/> Or what? The thesaurus files that installed by default with SQL Server...more >>

I'm running into an timeout issue in my production environment. I have several ASP.net (2.0) sites running on the same web (IIS 6.0) server. They all point to the same set of code but run in seperate application pools. They all talk to there own sql server 2005 database running on a seperate s...more >>

Hi! I'm using fulltext indexes and I can't understand what happens in the file system. This is my test: 1. I create the catalog: CREATE FULLTEXT CATALOG FTC02_slave ON FILEGROUP FG01_SLAVE WITH ACCENT_SENSITIVITY=OFF and SQL Server creates these folders: \FTC02_slave \FTC02_slave\Ms...more >>

Hi there :) I have a problem and don't know how to resolve it. I had sharepoint portal server 2003, then it was upgraded to 2007, but after that two meeting workspace been lost. Lost from sharepoint site, but not from the DB. Wrote to sharepoint group and one guy just started with step buy ...more >>

Hi, It is strange that full text search for the same db and tables is working in one server, but not in another one. Error log for this: Event Type: Warning Event Source: Microsoft Search Event Category: Gatherer Event ID: 3024 Date: 5/20/2007 Time: 2:28:23 PM User: N/A Computer: GJI...more >>

Hello, from SQL Server 2005 I access a index server an another computer (cp- tkl) select * from openquery(IDXNAME, 'select filename from "cp- tkl".idxc..scope()') When I use windows authentification it works and I have a result. But when I use SQL Server I have no result (and no error me...more >>

>From what I have so far, Sql Server does not provide a way to return its query results hits in a highlighted format. I was able to programmatically get this working for simple searches, where I simply do a find and replace based on the search criteria. But this will not work for plural results ...more >>

I am using asp.net (C#) to create full text searching using SQL Server 2005 in our application. Everything is working fine, but I am trying to highlight the resultset keywords from the full text results. Can sql server provide you with a way to highlight the keywords from the full text search? ...more >>

It seems for me that SQL Server does not provide Hebrew-specific word-breaker and stemmer for full-text search, only some generic ones. Am I correct? Are there any plans to officially support Hebrew? Does anyone aware of some third-partly product to add this support today? Any comments apprec...more >>

Hello everybody, I have installed SQLServer 2005 for take advantage of full text seach features. When I start full population, there are some rows that cause error and not are indexed. I see the log in C:\Programmi\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\SQLFT0000700005.LOG. In this fi...more >>

Hi, I receive Message 7653 when I try this: CREATE FULLTEXT INDEX ON Products (Name LANGUAGE 0x0) KEY INDEX ID WITH CHANGE_TRACKING AUTO; The message states that ID is an invalid column because it must not allow nulls, be unique and the like, but ID is really a simple int primary clus...more >>

Hi, I brought this up once ago, but I read something which might open a new possibility. What I am trying to do is this: select p.Name, p.Score, ft.Rank from Products p join ( select [key], rank from containstable(Products, Name, '"Screw*"', 10) ) as ft on ft.[key]= p.Pr...more >>

I have tried install Microsoft full-text search engine on SQL Server 2000 (Developer version). The operating system is XP Pro SP2, with .net framework 2.0. With every variation I have tried to install it I get: "Installation of Microsoft Full-Text Search Engine Package Failed (-2147220991) ...more >>

I have a table that has 20m rows in it, with 4 full-text search enabled columns that are of type text in a SQL Server 2005 x64 EE environment. I try to run a "alter index [primary clustered indexname] on table rebuild" and it never finishes. This table has records deleted in it quite f...more >>

Hi, I have a web app which allows user to enter complex queries with (),and,or,... If the user enters a stop/noise word liek this "termA and noiseWord and termB" I get no result. I see no simple way to remove the stop words from a complex query without writing a complete parser. The only solu...more >>

we are using sql server 2000 db in my project. we use full text search for searhing products with partial strings. when i am using LIKE clause i am getting all the results with the partial string. but when using FREETEXT i cant able to get all the product series with the partial string matc...more >>

Good Day, I have installed SQl server 2005 edition Advance but can not see any tree items in the management studio for Full Text searching. If I right click on a database table I do not have an option to create an index. Also if I right click on a database and select properties then file, t...more >>

I am using sql server 2000 in my project. we are using full text search for searhing products with partial strings. when i am using LIKE clause i am getting all the results with the partial string. but when using FREETEXT i cant able to get all the product series with the partial string mat...more >>

Hi We are working with a sql server 2000 using full text search, which works well so far. However, we are not sure which is the best way to ensure the full text search is always working properly. As changes to the database should be immediatly reflected in a search query, we have change tra...more >>

I am trying to figure out why thesaurus search is not working on my computer (installed SQL 2005 and have been struggling with a thesaurus search for a couple of hours now, tried all the ways Microsoft suggested in the book online), and just realized that I could not even find tsschema.xml fil...more >>

I have a nightly job scheduled by the SQL Agent scheduler to run full-text creations nightly, and I have noticed that the following error message appears during the process of trying to index a number of tables (but not all). can someone please provide some advice as to what might be causin...more >>