I'm running Sql Server 2000 SP3 (Developer edition) on Win XP Pro. When right-clicking on my database in Enterprise Manager, under the New menu there's no option for creating a Full-Text Catalog. The usuals stuff such a as new tables, views etc are though. Any help greatfully appreciated. ...more >>

Not sure if this is the apporpriate group but I have a problem that involves text searches I have a client that has a database with around 2.5 million records that include 4 text fields they would like to search on. (the table is wider it includeds a total of 50 fields) They want to be able to se...more >>

I use a simple test server with SQL and MSSearch for development work and up until recently it was handling full-text searching just fine. I updated the box to Win2K3, and still no problems. But then I modified noise.eng, and in the process rebuilt the catalog. Now whenever I try to populate t...more >>

Hi, I am using a full-text catalog to perform search inside a 1GB table. I have created fulltext catalog as usual methods, selected the necessary fields for the catalog from the table. When I want to make a stress test over the search fucntion, it deoesnt return any data if I use more then...more >>

I have an SQL account that uses FTS on SQL 2000. I originally used Incremental Population to index the work done during the day. However, the indexing process was carrying over into the next work day. Therefore, last week I changed the method to Change Tracking with Update Index in Backgrou...more >>

Hello I've searched high and low - looked at John Kane's prior responses and this is incredible. We did a SPS install and upon testing the WSS site search capabilities realized the search wasn't working. Upon further research we found that the catalogs weren't being populated *** This is not a ...more >>

Hi all. I have a requirement in which customer fills in a form. The provided form fields are searched against the coulmns in customer table. For example FirstName is searched against FirstName in the table and so on. If the form data is same as that of a table row than it is 100%. If for ...more >>

Hi I have SQL Server 2000 running on a Windows XP platform. I'm trying to add a full text index to one of the tables in my database. However, I'm not sure if I've got this feature installed. When I right-click on one of the tables, the "Full-Text Index Table" option is greyed out. sp_f...more >>

Hello, (I also posted to the WSS newsgroup but remembered somebody suggesting that this type of question might be better answered in the sqlserver.fulltext newsgroup). We recently had to replace our discs with larger ones. So we ghosted the original disc containing the WSS dbase, configur...more >>

Hi, I am a programmer with no SQLServer dba experience and have set up a full text index on two columns in the same table. The index is working fine except for when a noise word is used in a search. My problem is that I have been unable to remove the noise words. I have searched the drive and ...more >>

Trying to decide if we should use large varchars or text fields for some general notes type fields. We don't really need to do any extensive text searching. A like query would probably be sufficient. The number of records will be way < 100,000 and the app's relatively small at <50 users. Wh...more >>

I am using Fulltext search in a web application I wrote for our company that is bascially a knowledge base search engine - the app searches and returns matches against our SQL 2000 database. The problem I am having is this: I cannot seem to figure out how to search for phrases, booleans, and ...more >>

Hi Help needed on Full text indexing multiple partitioned table Let me explain u the actual scenario I have a big Base Table that holds ntext columns(2columns) and other columns that are full text indexed to be used in FTS. This Base table grows every day with new data being inserted every day....more >>

I'm moving my STS sites to WSS, and I'm running into a bit of a problem. We've got everyone on our team adding a category to their documents to help us search and organize them. However, seach under WSS (w/ SQL and Free-Text search) doesn't pick up the category field in my Word documents. I s...more >>

I've created a catalog against a fairly large table (around 900 rows) and selected Start full population from the catalogs context menu. A message appears saying it started populating successfully. However 24 hours later the Item count is still 0 and catalog size 1MB. I've tried restarting the FullT...more >>

Hi, I have an asp that perform a full text search against a sql server 2000. Everything is working fine but i was wondering if it's possible to highlight the search words of the hits , for example like google does. Any idea how to do this? Thanks in advance, Robert. ...more >>

All I have the Developer edition running on XP Pro. I "added" FTS as it was not done automatically during the regular installation. The box is checked when I run the installation CD and check the options that I can add I cannot however get FTS to enable. When I try to access it under the Ente...more >>

Hi, Having discovered that MSDE doesn't support either Full Text Searches or make available the Enterprise Manager Tool, I am looking for the least expensive version of MS SQL Server that will support these two features on a desktop running Windows XP. Thanks, Mac Littlefiele ...more >>

Hi everyone How can I search database records in table1 such that the query returns the matched records and their percentages to which they are alike. Actually the site administrator wants a search facility such that whenever he wants to register a new customer, fill out the whole reg...more >>

MS Windows 2000 Adv Server SQL Server 2000 The FTS catalog is stored on the same box as SQL Server. There are two applications that access a SQL database. I have one application that stores data from an OCR process in a SQL table. The table includes a timestamp column. FTS indexes one te...more >>

We are using Full Text Search on our production SQL Server (Active/Active Cluster, MSSQLSERVER EE). Within the last week we have not been able to rebuild the FTC on any database on one node/instance. We get the following message: Server: Msg 7608, Level 17, State 1, Procedure sp_fulltext_data...more >>

hello i created a very simple catalog with one full text index (only three rows on a table). The catalog filled up without problems and after 5 minutes it's ready, containing 20000 elements. But after a couple of hours the catalog seems empty. Under Properties it shows suddenly 0 elements but...more >>

Replication: Is it possible to replicate Full-Text catalog from one server to another...If so How? Thanks in Advance...more >>

Hi all, How do I get a table that has been Full Text Indexed, whose data has been input through an HTML editor to be searched by SQL without searching the HTML tags and code. I have a bunch of pages on my site; the content of which is stored in a Sql Database. When I search for the word "...more >>

I just read Andrew Cencini's article on FTS in 2k5 and from what I read I think its perfect for my projects needs (we have a need to search millions of docs per client) but I had some question on the performance info he mentioned. Andrew stated that "Scalability of the text engine at indexing ...more >>

I want to trigger full/incremental builds from my asp.net app. How would I do that? tia James ...more >>

I am trying to enable a database for full-text searching using the following command: exec sp_fulltext_database 'enable' and getting an error: "The Microsoft Search service cannot be administered under the present user account". I've looked all over for a solution to this problem. ...more >>

sir, i am mohammed hussamuddin,i am getting a problem in transfering the database from sybase to sqlserver,i would be very helpful if u give me is there any tool available to transfer database from sybase to sqlserver,plz give the step by step operation to performe it. thanking you ...more >>

Full-Text index scheduling is not working on one of our servers. I can right-click on the applicable table and select "Start Full Population" or "Start Incremental Population" and the index updates with no problem. The scheduled updates just don't seem to do anything. Currently, the schedule c...more >>

SQLServer 2000 on Windows 2003 I have full text indexing on one table and would like to use Change Tracking to maintain the index Please could someone explain the difference between the options Update Index vs Update Index in the Background What happens if you hvae both options selected Many tha...more >>

Hi, i have a full-text table like this ------------------------------------------ | Description | Info | Extra_info | |-----------------------------------------| | xxx | xxx | yyy | | yyy | yyy | yyy | | xxx | yyy | yy...more >>

Hello, I have run into a brick wall here. I hope someone can help. When running a search I get this error: Application Error: [Microsoft][ODBC SQL Server Driver][SQL Server]A clause of the query contained only ignored words. I researched somewhat and found that it could be that the no...more >>

I am a newbie here and am in need of some help. I am creating a Full-Text Catalog and everything has worked fine, until now. I have the columns created successfully for a full-text catalog. Here are my statements: CREATE TABLE tblTableName ( NameID int IDENTITY Not Null, ...more >>

Hi We're trying to set up full-text search. When I went through MS Full-text Deployment White paper, under Full-text Search Checklist section, the third bullet point Verify whether you have the [NT Authority]\System added as a SQL Server login and that the login has system administrator rights ...more >>

How to setup to search for indic , chinese and japanese characters along with english in the same nvarchar column. Can I full-text index the column that is nvarchar contains unicode characters all kinds of languages. Can I use freetexttable keyword for searching the unicode characters ...more >>

Select Col1 From Table1 fk_tbl,freetexttable ( table1, *,'?????') as key_tbl Where fk_tbl.id = key_tbl.[key] Co11 is nvarchar column, searching Unicode gives Server: Msg 7619, Level 16, State 1, Line 1 Execution of a full-text operation failed. A clause of the query contained only ign...more >>

The syntax for using freetext is: FREETEXT ( { column | * }, 'freetext_string' ) I put together a test like: SELECT description_of_problem FROM servicerequests WHERE FREETEXT(description_of_problem, @description) and it worked fine What I have a a text box in a search form that may or m...more >>

Is it possible or advisable to share tables between two SQL Server databases on the same server? One database is restored every night from an offsite source. Thus, any objects created in the local version are lost after the restore. Is it possible to create a new database locally which accesse...more >>

Please, help me to troubleshoot MSSearch Gatherer error. I am running SQL2k SP3 on Windows 2k DC and trying to setup full-tex index using Enterprise Manager Console, everything goes fine until I a trying to start full population. In the eventlog I got the following errors: Event Source: Mi...more >>

With 2k, for whatever reason, I'm unable to create a full-text index on image column type. Would anyone have any idea what might be causing this problem? Is it possible that Developer Edition doesn't allow this? Why would it allow indexing text columns then? TIA. lc ...more >>

I want to search out the record just inserted immediately, so I execute sp_fulltext_table @db_name,'update_index' after every insert operation. Yes. I do search out the record within 5 seconds. But sometimes I gets the error message: [Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]Could not co...more >>

Hi all. I have an application that stores document meta data in SQL database and the document itself on the disk. The problem is that i need to search both meta data and the documents and display the result in one table. So lets say i need to find a document with a serial number 123 (meta dat...more >>

does sql server personal edition or any other edition support full text search on win98 ...more >>

I have a database with a large table that is full-text indexed. I recently moved the transaction log file onto a different physical drive and in order to do this I used sp_detach_db and sp_attach_db. The unfortunate (and undocumented) side-effect of this is that the association with the current ...more >>

Hi, I'm trying to enable full-text search on a database. For this I'm using the Wizard in the Enterprise Manager. When I try this, I get an unspecified error and the Wizard exits. In the Profiler, I've found it's this statement that generates the error: sp_fulltext_database 'enable' This...more >>

i wish to design a search like we do on google, for internal knowledge base app if i use freetext then specific phrase like "gprs settings" is not sorted out from the bulk of the result if i use contains then specific phrase is sorted out but i cannot write hi there i am looking for gprs ...more >>

Hi All, Are there any statistics or rules of thumb as to what point you should consider splitting catalogues or merging them into one, for example should you make your desicision based on your user interface in any way (not always a good design approach though). e.g. I have 4 sets of distinct...more >>

I have a table that has a fulltext index on it. I insert one row into the table. It takes about 20 seconds before the row gets indexed in the background. Does anyone know a possible cause for this delay? Is there a way to get it to process updates more quickly? Is there some polling mechanism that c...more >>

I need to fix this error. Encryption not suported by sql server. Software SQL Server 2000 OS Windouws 2000...more >>

I have currnetly being trying to populate a full text catalog with the table having approx 14 million rows. The population fails when the system runs out of nonpaged pool memory. The system cosnsists of a Windows 2000 server SP2 in a cluster running SQL Server 2000 sp3 in not applied. ...more >>