Hi All! I am running Win2KAdv. and SQL2Ksp3. I have defined and populated a fulltext catalog in one of my tables. When I ran the full text query like select * from mytable where (fieldname,'word') I don't get any result back! I have popluated the table several times but no result and no error...more >>

Hi, There is a way to rename a full-text catalog? Thanks, Adriano. ...more >>

I have figured how that when i type in "bob and Joe" (and i am using full text search ContainsTable with all columns specified "*") that it will search each column for the exact text of "bob and Joe". My problem or question is how do I use fulltext if i want to have sql return the results...more >>

Hi, I had a look to the noise files, and in the same folder (..\MSSQL\FTDATA\SQLServer\Config), there are xml (tseng.xml) which represents a thesaurus. Where is it used. useful ? Any link ? Thank in advance Jean-Etienne ...more >>

Is there a way to get SQL server to ignore the ignored words so that a query such as: SELECT * FROM Party WHERE CONTAINS (PartyName, 'The AND Charles AND Group') does not fail? If not is there a way to query the ignored words file from the client so that the query can be preprocessed? Th...more >>

TransactionDispenserInterface: Result Code = 0x8004d01b...more >>

Hi, I have a database table (in SQL Server 2000) with a text field and I need to perform frequent searches on it. The table will have some 10,000 records at any given time and the searchable text data in this table will be updated frequently as well (say 6-10 times a day). Can someone please ...more >>

hi all, the bol says that this can be done and indeed it can, but i wonder about optimization. take this query: select * from table where id=1234567 and contains(txt, 'coffee') id is primary key and the txt field is varchar(500) which has been full-text indexed. table is large. > 12 milli...more >>

Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48 Copyright (c) 1988-2000 Microsoft Corporation Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 3) CREATE TABLE [CustomField_10012] ( [ext] [char] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTR...more >>

I have the need to detach, copy and then re-attach a large database that has full-text indexing enabled. There are 4 catalogs comprising approx 1 gb in total. I have read and re-read Q240867. It seems to me that it is saying that if I stop the Microsoft Search service, backup the registry ...more >>

I would like to edit the noise.enu file but it seems to be locked. I have stopped the SQL services and killed sqlmgr but something still prevents me from editing or even changing its name. ...more >>

I instaled a second instance of Sql Server 2000; let's call it SERVER\NAME1. Now I created a full text index in one table, but when I execute this: select * from t_mytable where contains(myfield, '"xxx"') I always get this error: Server: Msg 7619, Level 16, State 1, Line 1 There is ...more >>

I have SQL7.0 Standard Edition running on Windows NT4.0 that is running the MSSearch Service that was installed by an outside consulting company as part of the tasks completed for building our Website Search Engine on that server. I would like to move the search engine and website to a ne...more >>

I understand that in order to use incremental population I need a TimeStamp field. However, I want to allow re-population of a record only when CERTAIN columns are changed. For example: I have a table called Products , with Product_watched_counter and Product_title/Product_desc. I want ...more >>

Hi, If a full text catalog is developed on a Windows 2003 server, can it be restored to a database running on Windows 2000 Server (with the SQL Server versions on both being SQL Server 2000 Enterprise Edition) Thanks Anand...more >>

Hi All! I have added full text search in one of the table. I've right clicked on the table then used full-text wizard. It created fine and then it said I need to start populated the table. I did as directed: right click on the table then click start populating. I am not receiving any result from...more >>

hi all. i have a win2K box with sqlserver 2000, and i'm trying to get full text indexing to work. the ms search service is running under the local system account. sql server is running under a domain account with full admin priveledges. the enterprise manager shows the Full-Text Search support s...more >>

Hi, What permission must a user have to Rebuild Catalogs in Full-Text Search? Thanks. Adriano. ...more >>

I have several tables with 2 - 3 million rows, and many columns with nvarchar data. Our vb.net applications have many queries of the type: SELECT * from [table] where column1 = 'text'. Will implementing fulltext search help these queries in their present form, or would they need to be re-...more >>

Hello there I don't know if the question is for this forum. I need to store word document in sql server. Is this possible? If the question is not for this room can someone tell me which room i sould ask? ...more >>

what is #atable and its usage?...more >>

hello! I bulid fulltext index on my sever before. Recently i find that Microsoft Search Service ocuppys full source of CPU. Please tell my how i can solve it . Thanks a lot!...more >>

Folks, I'm doing some research on implementing FTS into a W2k/SS2K clustered environment to do "simple" text searches. One of the requirements I've been handed is to do a search for multiple words in a specific order .. So a user can search for acute & infarction and expect to receive ...more >>

I recently upgraded from sql 7.0 to 2k, then applied sp3 Here is my @@Version Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright (c) 1988-2003 Microsoft Corporation Enterprise Edition on Windows NT 5.0 (Build 2195: Service Pack 4) I'm having a problem popula...more >>

Hi, I've defined a full text index on 2 tables. first table has 2.5M rows and the other 17M rows. I've defined a separate catalog for each table. On each table I've indexed 2 coulmns, both varchar, one is varchar(7999) and the other is varchar(500). The server has one xeon 2.2 processor and...more >>

Hi all, I am working with a test database and a live database. In each database there is a bodyContent table which populates webpages. I have overwirtten the live bodyContent table with an up-to-date version from the test database. Now it seems that my incremental poulating is not working. ...more >>

Hi, I have a column called 'wide' and would like to search here for manufparts but my problem is: Manufpart comes with or without chars ('-' , '/', '?') like ML-1500 or ML1500. I would like to search to show this record regardless of what users type...ML1500 or ML-1500. Would some one help? T...more >>

When doing a FT search using the contains clause to search for the phrase "Deleted documents" I get no results. My text does contain <b>Deleted documents</b>. Is there any way to have it ignore html tags? Thanks ...more >>

Hi, I am getting error 7635 "The Microsoft Search Service cannot be adminsitered under the present user account" The SQLServer runs on a domain account and the search service runs on the local system account.Buitin\adminsitrator login is there..I tried verious options of stopping and starting...more >>

Hi! Recently I installed Sql server 2000 on Windows 2000 Cluster environment. Everything seems to be working fine except Full text service won't start in both nodes. In the application log the error is: Eventid: 10006 Event Source: Microsoft Search Event Category: Gatherer Event ID: 10006 D...more >>

Thank Hilary and John, I am finally able to run "exec sp_fulltext_database ..." on the server. There was some log on mismatch between the Microsoft Search and SQL Server. Now that the FTS search is running on the server, I notice that everything is slowed down severely on the server. I ...more >>

This error occurs when searching for something like "t.a.t.u" on our Windows Server 2003 SQL Server but not on our Win2K SQL Server. It looks like (on 2003) the word is broken by the dots into 4 1-letter words, one of which (a) is a noise word. SELECT * FROM table WHERE CONTAINS(*, '"t.a.t.u."...more >>

We want to index and search a large repository of data that resides on disk. Can we index this data without moving it into a database? I know Oracle UltraSearch allows you to index file system data and creates the index in a database. Just wondering if SQL Svr has anything similar. than...more >>

Is there a way to restrict the number of results returned from FTS query, i.e.: TOP 1000? Thanks! HH ...more >>

We appear to have an issue with full-text search where occasionally a document appears to not make it into our catalog. If we run queries against our indexes they always return reasonable results, but every so often a document that we know exists and should be in the result set does not appear. ...more >>

Why do I get this strange error when I try to add text to a column in SQL while in open table mode? "Transaction cannot start while in firehose mode" I'm adding text to a nvarchar column with 255 chars. Thanks. Robert O. ...more >>

Hi All, i have a simple query: select distinct(id) from bibl where contains( title, '"Term*"') the results start with..: A100200 A100200 A107434 A107435 I was hoping the distinct keyword would eliminate one 'A100200' result. Does distinct not work on fts queries ?? I one have one...more >>

Hi, based on my understanding, full-text search does not support multiple languages seach in one database. For example, if I have a table like this: text_value(ntext), lang(varchar2) ----------------- -------------- 'this is in English' 'US' 'this is in Japanes...more >>