SQL 2005 Full text indexing seems to stem "best" to "good" when using CONTAINSTABLE(FORMSOF(INFLECTIONAL. Is there anyway that I can confirm whether this mapping is due to the SQL 2005 English dictonary, and whether this entry is going to be removed, or if there is a work around. Mapping "...more >>

I was testing my system and found the following error when I entered only words, such as "The": Execution of a full-text operation failed. A clause of the query contained only ignored words. Now I understand that it may not find anything out there as it is not going to search for every d...more >>

Hi, I am trying to implement a global full text search on our SQL Server. Our app has several entities that are stored in the DB. I would like to be able to search for 'John Doe' and get results in all types of entities. Problem is: - FT Search does not crawl views. Unfortunately, each entity ...more >>

How can I get and install a full Thesaurus into SQL Server 2005 CTP? Thanks in advance! Wayne ...more >>

Hi I've just restored a database from a backup, usually I have to correct the path of the fulltext index in master.sysfulltextcatalogs after doing this, but now sysfulltextcatalogs is empty and has no entries. When I right click the table with the fulltext index I can see that it has a fullte...more >>

I have a commerce server database that uses a full text index to search product numbers and descriptions. My issue is that some of my product numbers contain single characters, "EMT 1" for example, and the Contains clause does not seem to treat this phrase as an exact match search when I do ...more >>

Hello, I have to implement Search engine for one website,which will be capabale of finding text from HTML,DOcs,and Db, For HTML and DOC search I am currently using Index server for FREE TEXT SEARCH. Now I need help about how to search text from SQL tables,whether FULL TEXT will help me,to f...more >>

Hello all, can anyone tell, is there anyway to reinstall/repair full-text without having to actually uninstall and resintall the whole Sql Server? Thanks in advance, - Arthur Dent. ...more >>

What is the meaning of the "paused" status of a catalog? What is still working and what isn't? Thanks....more >>

Hi, I have two databases on separate servers - db1 & db2. I use DTS to copy the tables from db1 to db2 overnight. Then I want to recreate the fulltext catalog on one of the tables in db2 using a SQL Server Agent job to run sp_fulltext_table: USE hm2 EXEC sp_fulltext_database 'enabl...more >>

Has anyone ever used or have any experience with Product called SQL Turbo, is a replacement for MS DTS claims to process indexing 100x faster, much more efficient than native FTS tools the tool is out at http://www.imceda.com Any thought/feedback would be great... Thanks, Bob...more >>

I know that with background updates the FTI is updated incrementally as inserts and updates which affect the indexed column occur. How can I tell if an FTI on a column has been set for background updates? Also, do you know if there is a performance downside to having background updates e...more >>

Hi, I need an article to learn customization of FTS for other languages. Thanks in advance, Leila ...more >>

Hi, I have a table like this: CREATE TABLE T1( C1 int identity(1,1) PRIMARY KEY, C2 NVARCHAR(50)) INSERT T1(C2) VALUES('test') INSERT T1(C2) VALUES('Xtest') INSERT T1(C2) VALUES('testX') Assuming that C2 is enabled for FTS, this query does not return "Xtest": SELECT * FROM T1 WHERE ...more >>

I have installed full text searching on a table on Sql 2000 (sp4 is installed). It is hanging while it is indexing. I have the re-indexing set at every 10 minutes. Any ideas? Thanks, Marc ...more >>

Thank you very much for answers on a previous question. I have one more: The docs say if metadata is changed on a table, a full population will be done. Does this mean any metadata, even not related to the index columns? What is really the scope of table changes that affect this? When w...more >>

I have a fulltext search in my query i am using containstable function .I have to search for keywords like '170st'.but it is returning all the strings near to it, like 168st, 200st,110st.I think it is taking the soundex function. Please help me Pradeep K V ************************************...more >>

I just started to work with sql server 2000. I want to write a query against "datetime" columns in the sql server 2000 database. I am to be able to do the following with the sql server 2000 "datetime" columns: 1. Be able to access the date portion only. 2. Be able to access the time po...more >>

Hello All, When I restore a backup on a different Server, It automatically creartes the records in sysfulltextcatalogs which refers the Catelogue path of old database. How to come out of this Proble? If I remove the records from sysfulltextcatalogs, then while enabling the Database for Ful...more >>

Hello. I am having a problem with fulltext search whereby it always returns no data. I have enabled full text search on the table and successfully created a catalogue, which according to the event log has been populated. I have tested with this query (found in this group) via Query Analyz...more >>

Hello, we have full-text search service running under local system account and we removed Builtin/Administrators from our logins and now our full-text catalogs are not getting populated and now the only resolution i see is adding NT Authority/System as a login and granting sysadmin privileges...more >>

I would very much appreciate if anyone could answer the following questions: How do we know with 100% certainty if a full population or incremental population is being done? The ent mgt dialog may say incremental, but we don’t trust it because we know that sometimes a full population is don...more >>

Guys, Im having trouble with Editing Noise Words files on Clustered SQL server. It appears that when virtual server sits on first node FTS uses M:\Program Files\Microsoft SQL Server\MSSQL$SQLDEV\FTDATA\SQLServer$SQLDEV\Config\noise.enu But when it runs on second node FTS uses C:\WINDOWS\sy...more >>

Hi, I've found a script with an sql operator : *= I have not found any reference to such operator on the Net, does someone have ? What does it mean ? thank you mathieu st.pierre ...more >>

hello, sql newbie here. I have 3 tables(user, education, career), each have their own catalog. Say I want to search for a person who lives in a certain city with a certain education and some prior job, where the category equals some int. sql: SELECT DISTINCT * FROM User INNER JOIN Educa...more >>