This is a strange request that has been submitted as "critical" feature of an application, and I am not sure of how to approach the problem. The application has a simple, perfectly good Full Text Search capability (it is searching on "resumes" and "letters". Now we have been asked to allow the...more >>

Hi everyone, I'm at my wits end. I have set up both a full & incremental schedule on a table that has an full-text index on one of its fields. Problem is though - its not starting off. I have tried it several times setting the time to start a few minutes ahead using both full and/o...more >>

When I made the jump to SQL 2005 from SQL 2000, the following query stopped working. ie no result set unless I remove the fraction 1/4. (Removing the fraction 1/4 works, but then returns many many rows) SELECT * FROM MAKT WHERE CONTAINS(MAKTX,'"valve" AND "SS" AND "needle" AND "1/4"') With...more >>

I am seeing some query performance issues on a full-text search on SQL 2005. My table has about 20 million rows, containing an integer primary key and a field of type text. This is running on a dual core Xeon 2.8 Ghz processor, 2 GB RAM, 15k RPM drives in a RAID 5 configuration. My query lo...more >>

I once had some SQL to see what document types are supported by Full Text Search that worked at least for SQL2005 and lost it. Can somebody post that again please? Would be nice to have for SQL2000 if it is possible also. Thanks...more >>

how I can remove "c" from my noise word and how I rebuilt my catalog to search on c#, c+, and c. ...more >>

How can I loop through or get a resultset with all files in an indexing services catalog? Is there a way to make the returning recordset contain all records? I want to go through and grab the FileIndex from all files. The files are static so I don't have to worry about the value changing....more >>

Are you able to use a column of data type nvarchar max in freetext searching. sorry probably a basic one....more >>

Hello! First of all sorry for my poor english.... I write from Italy... I'm using full-text search with SQL Express 2005 and I can't undestand a lot... This is the situation: - I'm using Italian word breaker; - I've removed all words from my noise word list (noiseITA.txt) - I've thes...more >>

Hi, We are using FTS in our search to get a performance boost over a traditional LIKE search. It is working really well, but there is one issue. We would like to index and search for text that look like "319.109.092". The search itself works fine now - after removing individual numbers f...more >>

In 1 database I have 2 cataolg files. how many times a day I must execute sp_fulltext_catalog sp? "Full" or "incremental" which type of arguments I must use? and how many times ?(a day or a week)...more >>

We have a site with 2 copies of the database a live and a staging one. Our client have an Admin facility to update the staging database and can then synchronise their changes from staging to live (or vice versa to roll back). Historically where we have needed to do large changes to the data...more >>

I have spent hours on this problem and I can not even find where to start. I have full-text enabled on 15 our of about 100 tables in my database. This copy of the database has been running for about 4 months. Everything was working fine except that search has stopped working on one table (tha...more >>

Hi, I'm using SQL Server 2005 and was just wondering if its possible to get the values set for full text indexing via I was just wondering if it is possible to script the full text indexes setup from the Management Studio (in a similar way as you can for db tables and sp's). Also, I've no...more >>

I have a table that has some VarChar(8000) fields in it. I have run into problems with records having more than 4000 chars in each of the fields which gives me an error saying that the record size too large ( > 8060). It is going to be a problem trying to set up some type of multiple recor...more >>

Hi, We have a fulltext catalog, configure with CHANGE_TRACKING OFF and we have a Timestamp column. After adding some new data, we execute an “ALTER FULLTEXT INDEX ON [MyCatalog] START INCREMENTAL POPULATION”. It’s work well but each START INCREMENTAL POPULATION, fire a master merge; as...more >>

Hi, I have a query which have fulltext search. The query cost of this query is around 3-4 only (Show in Execution Plan). I am using ASP calling VBCOM adodb way to execute this query. Why I always hit timeout for the first search (using Machine A). There is no timeout after that. Looks like ...more >>

Hi, Would below mentioned thing is possible in sqlserver 2005 full text. User Table - Table Id Description - Column name 1 'Mission Impossible' - a row I want to ge this row if the search criteria is 'pos'. it is simillar to ' %pos%' in like search is it possible to get tha...more >>

When I use the "Indexing Service Query Form", searching documents for the word "D=E9sir=E9", I get 50 matched records. If I run the following query from SQL-Server 2005 (on the same machine) : SELECT * FROM OPENQUERY (CVCATALOG, 'SELECT FILENAME, RANK FROM SCOPE() ...more >>

What exactly does the "NEAR" operator mean in fulltext search query? I searched the online book and could only find the following info: "Indicates that the word or phrase on the left side of the NEAR or ~ operator should be approximately close to the word or phrase on the right side of the ...more >>

Hello, I am trying to see what the limit is on creating FT catalogs per server. I have found 2 Non MS links stating 256 catalogs per server, but I really need to confirm this. Thanks for your help...more >>

Hello everyone, We set up replication yesterday and it runs beautifully ... once. After the first replication, we get the following error whenever we try to access any of the replication admin screens, with the exception of the "disable replication" screen: Error 18483: Could not connect to...more >>

Hi, I have an SQL Server 2000 Std installation with a full text cat on a large table containing 2-3m rows. When querying on particular words/phrases SQL Server reports too many results. Error Type: Microsoft OLE DB Provider for ODBC Drivers (0x80040E14) [Microsoft][ODBC SQL Server Drive...more >>

Hi, Anyone knows what this Information message means ? Informational: MS Search stop limit reached. The full-text query may have returned fewer rows than it should. This message is random and same search behaves diferently on different servers. On some servers with same data it pulls data...more >>

Hi Everyone, I have a performance issue with a SQL Server query and i need some assistance with it. It would be great if you could offer your inputs on it. We have a SQL Server database that is of a rather large size [20GB +]. The most significant table "Order_Detail" has a large number of ro...more >>

Hi, I m using Sql Server 2000 Full Text Search. I hv a table with a column of image data type . Full Text Search is working fine on this column. But it is only returning Binary Data. I want to show Search results in text format. I want to get my Searched pharase/word in simple t...more >>