Hi, Ok, say I want to pull back all '"picture ~ frame"' and '"pictures ~ frames"' so I do the following; FormsOf(Inflectional, "picture ~ frame") this results in syntax error. I thought inflectional would automatically do it if I put " around the near words. The first ones I listed do not...more >>

Hello, It is possible to search text in my blog use a query sentence instead of several key words? Which I mean, if I want to get to know "How rich is Bill Gates?", I can simply enter this sentence instead of enter "Bill+Gates+rich+how" in my search textbox. If it is applicable, how?I want t...more >>

I have a pile of documents I want to index. My plan is add their text content to a text field in a VS2005 express database, then use a full text index to index the document contents. In my particular situation I do not really need to store the actual text content once the index has been updat...more >>

Hello All. I have a Windows Server 2003 & SQL Server 2000 (SP4) EE cluster setup using FTS on one table. It seems that when one node was failed over it started throwing the following errors shortly after the crawl job starts: The crawl seed <MSSQL75://SQLServer/21ccaaa4> in project <SQLServ...more >>

I want to search in fulltextindexes for multiple searchterms in multiple columns. The difficulty is: I don't want only the records with columns that contains both searchterms. I also want the records of which one column contains one of the searchterm ans another column contains one of the sear...more >>

Hi We have a table that is approx 800,000 rows with about 6 columns of which 3 are full text indexed. This table is full text queried then the results are used to filter other tables in a "select * from maintable where category=.. and primaryid in (select key from CONTAINSTABLE(fulltex...more >>

Which is better to index. A view that pulls in all the fields I need and indexing the view or indexing the tables I need and then merge the indexes. I am looking for performance here. I have about 6 different tables that I am joining in the view and only gettting the fields I need. Thanks, ...more >>

Hi, We have suddenly started having a problem with a webserver locking up as a process called msftesql.exe uses 100% CPU on all processors. This causes the server to be so unresponsive that it can only be shut down by holding down the power button. We have SQL 2005 SP1 and SQL 2000 insta...more >>

Hi, I am trying to use freetext to return "best match" results from a database with movie titles, and it gives me a few different results than what I would like it to. I should properly mention that I have just looked at freetext in a few days, so bare with my limited knowledge. I hav...more >>

The gather logs are huge, full of mostly "success" messages, and are massively slowing down our FT population time. Can I safely delete them? ...more >>

Hello, Is there any way to work around the behavior of searching for a term which has hyphens in it? I've seen the article at http://support.microsoft.com/default.aspx?scid=kb;en-us;Q200043 which only suggests doing a non-FTS search. Is there no way to transform the search term so that i...more >>

I am undertaking a project which requires the ability to perform phonetic searching across business and personal names and addresses. This data is relatively uncleansed to date. The amount of work to cleanse the data is tremendous based upon existing data analysis. My thoughts are that if we c...more >>

Hi, Does anyone know whether we can get Unicode search working on Sharepoint services v2.0. I know WSS 2.0 uses SQL Server's full-text-search. Andy Bolton...more >>

Hello, I have a SQL Server 2000 sp4 server. Trying to install Full-Text Search. I can see the Microsoft Search service and it shows as started. But the Full-Text Search option in SEM is 'grayed out'. The FTS system procs also report that FTS is not available. SQL Server has been stopped/r...more >>

Probably been answered before but can't find it anywhere in these threads We are implementing an application for a recruitment company and need to search for skills, we are trying to use SQL FullText Search but it refuses to find C# which is definitely in the database. We have found the re...more >>

Hi there, Is it possible with SQL Server 2005 to add weighting to a column in a CONTAINSTABLE or FULLTEXTTABLE ? I've got the statment : SELECT ftt.RANK, [content].id, [content].title, [content].content_data FROM [content] INNER JOIN CONTAINSTABLE([content], (title, content_data), 'Su...more >>

i can again/still/no longer manage full-text indexes on SQL Server. i'm logged on locally to my server, as an administrator. EM is set to poll the server. Has anyone written a gui to manage SQL Server free-text indexing? ...more >>

I would like to use the Full-Text Search in MS SQL 2000, but I'm not sure whether I can use it in my setup. In my application the user is able to type some text (about 400 words). In the database I have a list of words that I would like to match to the text. Is it possible to use stemming e...more >>

I am having problems doing a "Full Text Search" on the MSSQL2005 database server for some search terms (those that have a dot or ampersand). There are no problems doing FTS search with "normal" words. We're using Microsoft SQL Server Standard Edition, version 9.00.2047.00 Build 3790: Servi...more >>

Hi all I'm saving doc,txt,rtf,msg and pdf files in binary format in image datatype column in sql server 2000. I've created fulltext indexing on the table. i'm able to search a string from the column if the file is of doc,rtf or txt.But the search is not conducted if the file is pdf or msg. ...more >>