I know that if you have to drop a full-text enable database and restore it, you will have to rebuild the full-text indexes. My question is, if you have a database where the data has not changed since your last backup and you restore over top of the existing database, is the full-text index's ...more >>

Why ? Why ? Why ? Msg 7696, Level 16, State 10, Line 1 Invalid locale ID was specified. Please verify that the locale ID is correct and corresponding language resource has been installed. When i check the Sys.languages the lcid is there. When I check the Word Breaker language it isn't. O...more >>

Hi there, We have a problem with a slow startup of the SQL 2005 full text engine on a new box. The first query (after a reboot or first query in the morning) against the full text index is very slow, it takes around 30 seconds to execute. The full text index is very small (~2 mb), so this s...more >>

scenario: I have a user interface done in Coldfusion that access SQL server 2K store procedure on server 2003 that perform full text search on a field of a table. I have remove all content of noise.enu as user can use anything as a search index. Why is it that SQL server or SQL Analyser s...more >>

Time Out Problem A single VB application links successfully to an SQL server. The application calls simple procedures to query the database. After 30s these queries timeout. If the timeout period is extended, all procedures return successfully. What is going on? Background info. ...more >>

Hi all! I am the IT manager for the Flemish Red Cross and I am looking for an existing tool/product that we can use to implement a full text-search (including webpages, Word documents and PDF's) on our new website, thta we're building on MS CMS and SQLServer. Any suggestions? We don't really ...more >>

I am storing Arabic texts with "Erab" (Erab is used with Arabic alphabets above or beneath the letter to show how the letter must be read) . But the user might not enter Erab for the search. Is it possible to ask fulltext indexes to ignore Erab?! Any help would be greatly appreciated. Leila ...more >>

When I restore a database it will place the catalogs in the default location "C:\Program Files\Microsoft SQL Server\MSSQL\FTDATA", how can I change this default location so that when I restore a new database, the full text catalogs are stored elsewhere ? ...more >>

Hi all, I have a table on SQL Server 2005 with a column (collation SQL_Latin1_General_CP1_CI_AS) that can contain multiple languages. Some of the possible languages include English, German, French, Kazakh, Arabic, Chinese (Simplified and Traditional), Japanese, Korean, Thai, etc. I tried...more >>

Hi all, I have a single table (TAB_FULL_TEXT_NET) , with only one field indexed in my sql catalog. I am runing queries agaist the catalog using CONTAINSTABLE select [KEY] objDocumento, tf.RANK RANK from CONTAINSTABLE(TAB_FULL_TEXT_NET, *, '42.55.14.1.2', 300) tf The problem is ...more >>

Hi, We migrated our database to SQL Server 2005 RTM Enterprise (build 9.00.1399.06) and we have noticed that the full-text index is returning significantly fewer matches in a containstable function compared to that of SQL Server 2000. We use the containstable function with a top_n_by_ran...more >>

Hi all, Appologies if this has been asked before, I have been searching for days now on how to do this without success. We have a database we would like users to be able to search I have enabled full text search and it works great but I cannot figure out how to make a web page to allow us t...more >>

How do I configure Windows 2003 to use the wordbreaker dll (infosoft.dll) from a Windows 2000 machine instead of it's own 'improved' version (LangWbrk.dll). The 'improved' version breaks all our searches for part numbers with hyphens in. Or descriptions with slashes in ie. 1/4 drill. Thanks i...more >>

Hi, I have a clustered 2005 server (build 9.00.1399.06). On the server I have 3 FT catalogues. When I created the first catalogue everything was fine. The catalogue built fine and returns results correctly (sooo much quicker than 2000!). Then I tried to do a full re-population. The fu...more >>

While installing sp3 or sp4 on SQL2000, I get a "Microsoft full-text search engine package failed" error message and the installation stops. Windows2003 server Any help would be appreciated. Thanks Ron ...more >>

I need to create a store procedure to perform incremental population of full text index table. The store procedure will be call from my program. Any ideas ??? -- xxx...more >>

Hello: Somebody knows how much distance between words uses the "NEAR" parameter? PD: Pardon for my English. ...more >>

Can any one help - my Full text catalog on a remote shared sql server has died and i need to recreate it completely - I have done this before but i've lost the code to do it. If I remember right what i did was use start --> run --> to run an exe in the mssql folder that connected to the re...more >>

Just wondering a few queries about the differences between programming SQL for MS Access, and programming T-SQL for SQL Server. 1. Is it possible to use the same general SQL statements/commands from a ASP page that was used with a MS Access DB, for a SQL Server DB? (Basically can you progra...more >>

I am using full text index to search on one table. Table can be simplified as (DiscussionID, Discussions) and DiscussionID is the primary key. I use freetexttable instead of containstable here. For example, I want to search on Discussions field with key word 'exchange server'. Interestingly...more >>

Hi, sorry for the cryptic topic. I wasn't able to come up with anything better. We are currently working on a project thats aims to keep all students thesis es in a database and enable searches on it via a ASP .NET web app. The problem we have is that some students write their thesis in ge...more >>

I have installed the Adobe PDF iFilter on our WSS server. 1 - How WSS knows about the PDF iFilter installation. 2 - Is there any place on "Central Admin" to add the PDF file type? 3 - Any place to add the PDF icon? 4 - Do I have to rebuild all my Full-Text Catalogs? 5 - Any reported major probl...more >>

select FulltextCatalogProperty(N'hippyzippy', N'PopulateCompletionAge') returns the time since 1990 from the last population date; anyone know where exactly it is retrieving that number from? I've been looking for a while; and its proving to be more difficult than I thought. thanks m...more >>

Hallo, I tryed to add pdf-files that are stored in a image-column to full-text-search. As mime-type in the "data type column" I used "application/pdf". So, I can see at the "unique key count" that the files are read from the index but I can't find anything in the files by searching with contains...more >>

Hello, We are running SQL 2000 sp4 with full text search, recently we are getting 100% CPU over extended period of time and the only way to resolve this is by killing the Mssearch.exe process. (we tried to restart the service but it hang) the Microsoft search service is running under local syst...more >>

Hi, Does MS SQL Server 2005 Express Edition supports full text search? Is it possible to download and use FTS? or I had to use other SQL Server versions? Thanks ...more >>

Hello. I'm using SQL Server 2000 SP4 on a Windows 2003 machine. I've cleared the noise.enu (and noise.eng) files of all noise words, restarted the MSSearch service and rebuilt/repopulated all catalogs but still seem to get a problem when running certain searches: "Execution of a full-text...more >>

I'm having problems creating a new Full Text index in 2005. My environment: Windows 2003 SP1 Ent Cluster (Active/Active) SQL 2000 SP4 on one side SQL 2005 on the other. When I go to create a new index using the GUI, as soon as I click on "new Full-Text Catalog..." I get this error: Prope...more >>

I have a clustered SQL Server 2000 and have created a search catalog for one of our databases using MS Search. I am getting some weird behaviour: When the cluster group is running on Server1 the index gets created successfully. However if I move the cluster group over to Server2 the index fails ...more >>

Hi, I'm new to fulltext search and am having a problem formulating a query. I have a table with key, title, description within it. I'm trying to do a search, but weight results in the title higher than the description. I've only written this so far. select [KEY], Rank, listing_id, title...more >>

On one system a search for 21-147 returns 1 result - which is the correct way I need it to work. However on my new system, this does an OR search, returning all results with 21 in, and all results wth 147 in which clearly returns hundreds. These are product part numbers, they /must/ be searc...more >>

I can't find the answer to this anywhere. I have a 16+ Gig table with an image column that is full-text indexed based on the usual extension column. Some of the extensions are not the standard ones with the basic filters. For these extensions I do not want to be indexed with the full-text sea...more >>

Hi all, As sp_fulltext_catalog has now been marked for removal in future versions I'm trying to migrate the following statement to 2005 syntax; EXEC sp_fulltext_catalog 'MyFullText', 'start_full'; But, there only seems to be a rebuild option, not the ability to start a full population. H...more >>

Hi all, I do not if this is the right group to place my question. Anyway here is: All of you know about the "Did you mean:" functionality that Google shows when you type the wrong word, or if there is a better combination of words to performe the search, right? That is what i am talking abo...more >>

Hi all, I am unable to populate a full text catalogue in SQL 2005 Developer edition (RTM). I have managed to create it and include the tables I want, rebuild it completely and make queries against it. The following SQL, executed one statement after the other shows some strange behaviour, it...more >>

What new features does full text search support in MS SQL 5.0? ...more >>

Hi, We have a table named "testIndex" which has columns: id (primary key), cv (image) and indexCol (varchar). We ran the following scripts to create a full text index on the column "cv". EXEC sp_fulltext_database 'enable' EXEC sp_fulltext_catalog 'TestCatalog', 'create' EXEC sp_fullte...more >>

Hi All I have enviroment where I have 2x SQL Server 2000, one publish data and the other one subscribes to the data, this is configured as a one-way snapshot replications. On the subscriber, Full-Text is enabled and in the database (that receives the replicated data) I've created an Full...more >>

I have a 2-tier application The top tier is a web tier (IIS/ASP) and the lower tier runs SQLServer. This works fine for ALL database calls, except when it requires a full text query. The error message received is: --------------------------- Microsoft OLE DB Provider for SQL Server error ...more >>