I'm using SQL Express with Advanced Services and can't seem to get the FREETEXT or CONTAINS predicates to operate how they should. I've gone as far as create a simple database, with one table, with one column that's indexed and those still aren't returning anything other than direct hits. ...more >>

I'm working on an aplication that could benefit from having the hit location inside of a column. For example A Column has "United Stated Education System : Educational Stuff" The full text search might match Education and Edicational from the word eudcation. But I can not see any clear ...more >>

Hi all Quick question, I have a set of full text catalog files that we would like to use to re-create a set of catalogs on a new build database, as part of a build script. I have copied a set of files to a devstore on out SAN with the intention of moving these to each local file system before...more >>

Is it possible to list all of the current Full Text Indexes on a given database by using a command or statement through the query analyzer? My problem is that i setup a full text index for a database 1 year ago and have since forgotten its name and from what i can tell my sql/vb.net doesnt ...more >>

Hi, I am executing the followings SELECT and the results are not as expected. =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D Search 1 SELECT Valeur FROM RechercheChaines WHERE CONTAINS (Valeur, 'HYDRO-QU=C9BEC') V...more >>

What was the verdict on the two ways to perform the full-text query, contains vs. containstable? It seemed the original poster found that containstable worked faster and wanted to know if was essentially the same query. The question also was why did the containstable work faster. It didn't...more >>

Hello All, I was reading BOL, and I came across this statement: "Many document types can be stored in a single varbinary(max), or xml column. Microsoft SQL Server 2005 supports certain document types and provides a filter for these types." But I can't find any other info on which document...more >>

Hi, I am using SQLServer 2000. When i searched for 'C#' or 'C++' Ex: CONTAINS(Table.*, '"C#"') getting results that does not have 'C#' or 'C++'. Any help? *** Sent via Developersdex http://www.developersdex.com ***...more >>

Hi, Sometimes, I got the following error while trying to perform a database backup. This backup is done on a regular basis using a maintenance plan. There is a full-text catalog in the database and there must be a conflict somewhere. Any idea? ------------ Date 14/09/2006 08:00:11...more >>

Env: sql 2k sp3 Ent. ed running on win2k3 active/passive cluster When SQL SP3 was applied on the cluster it failed to upgrade ms search on the passive node causing ms search on the two nodes to go out of sync. Because of this the catalog created on the active node isn't usable on the passiv...more >>

Hiya, I have several database on a SQL2005 server. They have fuill text indexing enabled. They all have one catalog referred to one table. Currently they have not been populated so are therefore empty. Problem is, everytime we do a backup of these databases it tries to PAUSE and RESUM...more >>

We have SQL 2000 on one server. We are trying to configure full text searchin within Project Web Access on another server. We have noticed that the "Microsoft Search" service is not even listed on the Project Server. How is that added/installed? Thank you. ...more >>

Can I use FTS for eml-files stored in database?...more >>

I have recently used the 'top_n_by_rank' clause in a full text query in order to reduce the query execution time. Here is the senario - we have a table called 'article' that has three fields. ID int, Active bit, Body varchar(8000) I want use the top_n_by_rank clause to only return the top...more >>

Hi i am trying to use full text index with farsi language . but simply it does'nt work do you know why fulltext index does'nt work with farsi? because i know that full text supports natural languages. Bye ...more >>

Hi I would like to know what are the caracters that are considered as word boundaries in FTS and if there is a way to configure this list of characters. My question is about the '/' character which doesn't seem to be a word boundary in FTS and I would like to change this behavior. Thank...more >>

Seemingly a simple thing but something is wrong: SELECT * FROM PERSON WHERE company_id = 7410 AND CONTAINS(first_name, 'Daniel') takes 2.5 minutes. SELECT person.* FROM CONTAINSTABLE(PERSON, first_name, 'Daniel') AS a JOIN person ON a.key = person.person_id WHERE company_id = 7410 takes und...more >>

Hello, I have a query that uses the CONTAINS function but I got a strange result. I have a table with product information on various tv's. Part of the query is: WHERE CONTAINS(sb_pvomschrijving, ' "PDP" AND "436" ') To my opinion this query has to return all records where the field sb_pv...more >>

I have a FT catalog with "product_name" and "product_description" fields in it. If I do a containstable search using "*" to select all the fields, my weighted results have weightings on "product_description" higher than on "product_name", whereas I want to have hits on "product_name" always hi...more >>

If I use a containstable query against a word like "M&M" I get a response Informational: The full-text search condition contained noise word(s). (0 row(s) affected) Even though there are many rows with "M&M" in them. How can I get around this? ...more >>

I have an FT Index on product names, and I'm trying to devalue common words that would appear in many names. I'm using a query like: select p.product_name, k.rank from products p inner join containstable(products,product_name,'isabout ("Bob&Ray" weight(.9),"video" weight (.1))') as k ...more >>

Since difference and soundex functions can't be used with ntext. How can i make fuzzy search to a fully indexed text database field that has ntext as data type ? any special tricks ? or do i have to change it to nvarchar to make it work ?...more >>

hi guys, wanted to know if anyone has figured out a way to perform customized proximity searches in SQL Server (i.e., find a word only if it's within 10/20/n words of another specified word). The NEAR operator is not nearly specific enough for my needs...thanks! ...more >>