Hi, The problem started because the client's hardware malfunctioned and he needed to move things to a new computer. So, we installed SQL 2000 on the new computer, ran the SP3 updates, and installed the specific initial database using our installer. After that, we restored the database ...more >>

Hi, We are using Full Text Search on SQL 2000. The search performance is fine. Our problem is that when a record is added to the table, the average time it takes before we can find it with a CONTAINS is 20 seconds. This is with only one user connected. The tables has only 200000 rows. Th...more >>

I'm dynamically creating a SQL statement that takes each word from a sentence, and using the WEIGHT command, searches a number of fields twice for each word - once with a given weight for the exact word, and once with half the weight for a partial match (by putting asterisks at the start and end...more >>

John, I've bumped this up because I have been so busy on other things that I was afraid that it would get lost in the other messages.... On my SQL Server, as I had mentioned, I have two Server Groups: (local) and SVR1/SHAREPOINT. When I try to use the SQL Analyzer to run the EXEC... you want...more >>

How does FTI on SQL Server 2000 deal with semicolons? I have some unexpected behaviour, see example below:- Assume I have this text in my database: ....Business Objects, (Nasdaq:BOBJ)(Euronext Paris ISIN Code FR0004026250-BOB), the... When I execute this statement: SELECT [news].[id]...more >>

I'm concerned about the ranked order that search results are returned to me from a stored procedure using full-text searching. These are the values inside my table: Apple Apple 1 Apple 2 Apple 3 Apple 4 Apple 5 Apple 10 If I do a full-text search for "Apple", and if my stored procedu...more >>

I'm having a package for the WEB error when installing MSSQL 2000 in a clustered windows 2000 advance server. I have observe the task manager what process was invoke when the error appeared and it is MSSEARCH.EXE. What can I do to complete my installation? Thanks...more >>

Hello - sql server 2000 sp2 I have a catalog that has been recovering for 3 days. It finally says "idle". However, it is missing about 20,000 records. The table being indexed has a little over 3 million rows and the catalog item count shows 2.8 million. I ran a ft query and it is mi...more >>

Hi everyone, I've enabled full-text search on my relational db. I have some problem executing search between related tables. For example: Master Table: Events Events.ID (unique identifier for event) Events.Location (string that contains the name of the city of the event) Child Table: Ev...more >>

Hello everyone, I am trying to find some benchmark that compare different database engines. I already know what are the pros/cons of Oracle vs SQL, but I have to come up with metrics to help us choose the best database for our needs. Thank you! Martin Paré ...more >>

Operating System: Windows 2000 Server Server Brand: DELL (Intel Penium 111, 1133 MHz) Sql Server Standadrd Edition Ram: 2GB Processor: 1 Fulltext Index Size: 52MB Number Of Rows In Table: 1.2 Million Aprox SQL SERVER MEMORY SETTINGS: FIXED, 1945 MB MINIMUM QUERY MEMORY SETTING: 1048576 KB A...more >>

Is it possible to enable full text indexing on SQL Server without re-installing (assuming that the full text option was not selected when SQL was first installed)?...more >>

I am really new to SQL and I am hoping someone can give me some basic help with writing a sproc. I have 3 tables Table 1 UserId - int UserRole - int Table 2 UserId - int UserName - char Table 3 RoleId - int RoleName - char I am looking for a sproc that will return a table like ...more >>

I want to give users access to full-text searching and presume that I can let SQL-server do all the dirty work. If I pass in a syntax error, things fail as expected and I get an appropriate error message in the exception. If I pass in a query with only "a" (for example) with only ignored words...more >>

Are there any standard ways to optimize full text searches. Are there any dbcc or any other commands to do so. Thanks, Alok. ...more >>

I have data (pages of reports) stored in the text data type. The table w/ this data has a full text index on it, and I am trying to query for monetary values such 123.45 using the CONTAINS predicate. Ex. select * from tablename where contains(document_text, '123.45') The problem is tha...more >>

Is there a way using full text search to search on the title of a document (i.e. The title used by Microsoft Word in it's title field, not the actual name of the file)? I have stored procedures using FreeTextTable, but this doesn't seem to be returning results based on the titles. Is this the ...more >>

I have about 15 million rows in one table with about 8 gigs of text that I have a full text index set up for. When I need to search everything, this works well: SELECT [Key], Rank FROM CONTAINSTABLE (Items, Content, 'searchfor', 200) ORDER BY RANK DESC The key is the identity column (Item...more >>

I have a searchable fulltext column.that has multilingual content in it. Some users run a non-English query, while most run English-only queries. What's the best tactic to make the non-English/multilingual queries to be run against a neutral catalog (like it is now), while making the Engli...more >>

When I use filtdump/b dom.pdf,an error occure. the prompt is can't find tquery.dll? Why? ...more >>

Hello you geniuses, I've read so many articles in here about full-text searching that it's all beginning to slip out of my ears. Most everyone seems to have gotten something working but then it ends up with problems or issues when configurations change or something externally effects it. A...more >>

Would u like to mail them to me or tell me where to download them? ...more >>

...more >>

Hi, Is it possible to define a specific order for full-text data to be populated ? I've got a few hundred thousands rows indexed that can be completely renewed sometimes... When this "big update" happens, I always rebuild the FT index, to avoid delivering inaccurate results (as almost all the...more >>

I have an application in Power Builder 6.5 and I use SQL Server 2000. How Can I create pdf files?? I want to create pdf files using Power or SQL. Is it possible?? *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it!...more >>

As my customers are mainly not-English-speaking, I'm used to prepare specific versions of the file "noise.dat" for all the indexing for neutral language. Anyway, even though I'm not including the paragraph symbol (§), I've realized that this character is automatically considered as ignored w...more >>

Hello I need to move all folders off of a drive as that drive is being replaced. One of those folders is FTDATA. Can I just stop SQL Server, move the folder, modify the FULLTEXTDEFAULTPATH in the registry to point to the new location, and restart SQL Server? Or, given that this application do...more >>

Hello, I am dynamically generating and SQL query, which could contain illegal words. I receive an exception and dialog box, "System.Data.SqlClient.SqlException: A clause of the query contained only ignored words". Is there a way to catch that exception and resume processing (of the rest of ...more >>

I have a couple questions about fulltext searching.... 1) FULLTEXTTABLE appears to be my preference. I have 3 columns in my catalog. I'm getting results, but I think the rankings should be different. My lower rankings should be higher than the highest ranking results. Can I give weight to spec...more >>

Hello everyone, My company is in the middle of coding a complex search function which takes over most of the features that full text indexing contains (such as stemming and stopping). However from reading about full text indexing it appears that for a column containing rows of pure text doc...more >>

The following is from an application that uses Microsoft Access to survey text to discover the occurrence of words of interest to the user. A string search where tblDoc.DocumentText is the text of the document to be searched and LevelOne.word is a column in a table containing 12,000 words...more >>

Hello, I've got a problem with the Full Text Search of MS SQL=20 Server 2000 (SP3). I've created a new Full Text catalog (FTC) on a database,=20 including one table and one textfield for searching. Up to=20 this everything goes fine. Population runs without=20 creating an error. But after ...more >>

Hi All I am using SQL server 2000 with SP3 on Windows 2003 server. I have scheduled a job to populate a full text index incrementally. Everytime it runs the job to populate the index table it writes some messages into event log. Like this: 1. Event Type : Information Event Source : Mic...more >>

I also have the 'greyed-out' menu problem for full-text indexing and have researched every post and article available. The MSSEARCH service is running, and the SQL Server 2000 is upgraded through SP3a. The Security tab for the server is set for "SQL Server and Windows" authentication and...more >>

Hi, I am sure that my question was posted before but cannot find anything. So here it is again: 1. Is there a way to search for "T 3" or "???" using contains without changing the noise-text file? 2. No kind of escape character for the space in "T 3"? Any help is really appreciated! Than...more >>

Dear all, I've build a FullText Indexing at Enterprise Manager. However, when I run the following query, it does not have any result return: select u_documenttype, u_document, u_filename from doclib where freetext(u_document, ' "category" or "eis" ') Does anyone have any idea about my sit...more >>

Hi, I'm hoping someone might be able to help with a problem we're having with SQL Server: A couple of months ago our server had to be rebuilt after installing some hotfixes from Windows Update; the server hung on shut down, was reset, and didn't come back up again. The OS was reinstalled...more >>

Does it show you how to replicate over the internet. I have read it can be done. There are so many applications for this but little in the books or internet in general. Regards, Chris. ...more >>

Hello, For security reasons within our organization, I need to compare our = customer data with a "black list" that we are getting from an outside = source. I need to get potential matches and get this information to the = appropiate parties. =20 The problem is, the information is coming i...more >>

I have a very large number of databases that are on server B. These all have full text catalogues that reside on that server's D: drive. This is my "production" server. I have a back-up server that I restore the database back-up files on. When I come to re-build the full-text catalogues, th...more >>

I've posted this before in microsoft.public.sqlserver.programming, and someone suggested me to post to this newsgroup. Anyway, I have articles table like this: tblArticle ---------- article_id article_title article_text article_title and article_text are part of full-catalog. And am...more >>

Hi, I've currently got three tables, with the second being a link table to establish a many-to-many relationship, and I'm trying to do a full-text search. I want it to bring up instances in the first table (only one row of the left table per search) where the text is found, and increase the r...more >>

We are running SQLServer 2000 on Win Server 2000. HP box w/2-3.0GHXeon/2GB RAM We have 30-40 databases with FullText indexing defined on one table which, in some cases can get very large both in terms of rowcount and rowsize. Some rows contain 25mb of text. Per Microsoft: Memory Configurati...more >>

Is there a way to tell the system to re-index a table after a change - any change is made to the table? Is there a way to tell the system to re-index using a stored procedure? Thanks, Tom. ...more >>

I'm creating an IFilter implementation for a custom file format. I've created a COM object that implements IPersist, IPersistFile and IFilter. I've tested the IFilter with the Indexing Service, Filtdump.exe and FiltReg.exe, and all seems well. However, when I try to use this with SQL Full Te...more >>

I have a table which needs to have a column called rank. When I run the following query I get an error about the table names being ambiguous. Is there a way round this. Regards, Chris. SELECT [Key], productdescriptionid, productdesc_name FROM FREETEXTTABLE (tblProductDescriptions, *,'biopsy') ...more >>

Hi All Just want to know, How can we reindex systems table? i.e syscolumns, sysdepends, sysusers etc. In case it can be done automatically, How can we let it reindex by itself? The problem is sp_help_fulltext_columns issue in nearly the same database but generate totally different exe...more >>

Hi, How do I best update a Full Text Index on SQL2000 sp3, for Merge Replication (Push Subscription)? Here is the config: Site 1: I have one table with one column (ntext), which I have created a full text index. The table updated once per day, data is never updated, always insert new r...more >>

To quote the MS SQL Server 2000's online book on CONTAINS: "If the text and asterisk are not delimited by double quotation marks, as in CONTAINS (column, 'text*'), full-text search considers the asterisk as a character and will search for exact matches to text*." Can anybody confirm the abov...more >>