Hi, I'm trying to install full-text search service on SQL server using command ftsetup.exe, but I always get error "FulltextSetup returned error code: 0x80000023". I've upgraded MSDE with SQL Server 2000 standard . Upgrade process did not install full-text search service, so I had to do ...more >>

Hello , all I try to run SELECT with contains function select * from a where (a.t , '"only*"') but my query doesn't find any rows, it 's happened with the word - ONLY. What's happening? Thank you. ...more >>

Does anyone know if this affects when the FTS os on the second node to incremental population? Thxs....more >>

Full text seach is working on my Development machine. I created a similar full text search catelog on my test machine.But I am not getting any results back.I chekced the event log..Every time it runs there are four warnings which says The message '-2147480624' for application 'Microsoft Sear...more >>

Hi, I am confused by the different method of population, of both Full Text index and Full Text Catalog. Currently, we are running a application (3rd party) on SQL 2000, and we have set the Full Text indexing to be "Change Tracking" and "background update". By having this combinat...more >>

I am trying to enable Full Text Searching on a SQL Server 2000 DB. I have full access to the system, but cannot get it to work. It is running as an Instance and the Search Service is running. I have tried running the Full Text Windows by logging into the Server using the Local Administrator...more >>

I have an installation that move their database to a cluster server. SQL2000 has SP3 applied. We created a new FTS against a single table, single row. The table has 500,000 rows of data. When I select "Start Full Population" the task completes immediately and the count is one. The edited...more >>

I have a job the runs nightly that does a brute force "exec sp_fulltext_catalog @FtcName, 'start incremental'" on all customer databases and all FTC. I noticed that for a few days in a row that in specific databases there are several FTC that always have a status of either "incremental popula...more >>

Can I search(one query) against columns from two tables.Please share a basic example.How does the ranking work in this case....more >>

Maybe someone knows if this is possible... I managed to get the Thesaurus working for full text searching, which required me to restart the msftesql service. So my question, is there a programable way to restart the service within the Sql Server API namespaces? If so, any ideas as to whic...more >>

like google Advanced Search in SQL full-text search? I use : CONTAINSTABLE(table_full_text_search,*,'"for" and "dog" ') to search the (all of the words).but the "for" is noise word,I cannot search... if i use FREETEXTTABLE it looks like return me OR search with "for" and "dog" Anybody ca...more >>

Hi, I have CRM database that contains full-text catalogs. Someone delete rows by mistake. I need restore this database to same server from last night backup, after database restore, do I need manually active full-text indexes or it will automatically enable since I restore database at same...more >>

Hello. This is my first experience with full-text indexing and immediately I'm having problems. I set up full-text indexing on the "referenceCompany" column of table "Reference" and ran the population routine. All queries against this table are failing: ---------------------- select * fr...more >>

Hello, I have full text in a MS SQL database table. I also have a string "Search" which contains all the keywords passed in the URL to the page.aspx. I want to use the keywords. What I have now is this: SELECT * FROM dbo.documents WHERE CONTAINS (*, '"ASP*" or "BOOK*"') Of course this...more >>

Hi, I am searching concrete feedback on SQL Server 2000 SP3 Server that have in place FTS catalog population with the following options: - CHANGE TRACKING - SCHEDULE Many thanks....more >>

I have a 10 million row table with two columns(name, address) full text indexed. I want to search the table for the first 200 occurances of "Bob jones" in the name field. I have ran another query to find out that there are actully 15,291 rows with "Bob Jones" in the name field. I want just th...more >>

Hi, When trying to set up "Change Tracking" with "Update Index in Background" the Enterprise Manager console freezes. Do I need to stop some Windows services to do that ? Configuration : SQL Server 2000 + SP3 Windows 2000 + S¨P3 Any help will be appreciated. Thanks. ...more >>

I have a database who's SQL Server backup file has been hovering around 33MB and has been growing only a few hundred kilobytes week for a couple years. I have since added a catalog and indexed a couple of tables and now this database and another one on the server--that should be unrelated--have ...more >>

I have a fulltext indexed table (aTest) which look like this (strCaption and strText are both fulltext indexed columns): lngStoryId strCaption strText ----------- ------------------------ ------------------------------ 1 Kerry Bush meets Kerry N...more >>

We're running full-text indexing on SQL 7.00.1063 (SP4). The database is for one of the larger applications we have, but we're a small company. The main table for the database, which contains the most text fields, only has 10000 rows in it. All-in-all, the indexing is probably only scanning 50...more >>

I'm implementing the search features on a web site. If I search for several words not in the noise file everithing is ok. If I search with several words and only one of it is in the noise file the query fails with Execution of a full-text operation failed. A clause of the query contained on...more >>

I've currently got a problem with a large full text index on table that has around 130 million rows. The table has a total of 6 columns enabled for full-text indexing, and the total size of the index is around 40GB. The problem is that the index will, on occasion, show 'paused'. It does this ...more >>

Hilary Cotter once mentioned that sql 2005 will replicate the full text index along with the table to a subscriber. I just tried it and it didnt work. I cannot find any documentation about this other than database mirroring. Can someone point me to some docs showing how sql2005 is supposed to ...more >>

Platform: win2k, sql2k std sp3a We tried to edit full-text indexing for table dbo.pages(already defined full text index) from SQL enterprise manager then we got by the end: The full-text index for dbo.pages has not been populated. To populate this full-text, use the "Start Population" menus ...more >>

Hi, we are using fulltext indexes computation on Production Server. MSSEARCH eats between 20 % and 40% in a regular manner. It picks up to 40% then goes down to zero but some secondes later will climb again to 20 and up to 40% We are using System SP sp_fulltext_catalog on a main table wi...more >>