Hi, I wonder if there is a way to make full text searches insensitive to non-alphanumeric characters such as "-". I have "7-UP" store in database. But I want users be able to find it with "7-Up" or "7 Up" or "7!Up", etc. Here is what I have in my noise files: a b c d e f g h i j k l m n o p q r ...more >>

I'm using Microsoft SQL Server 2000 and I keep getting a Runtime Error box popup (a lot of them that I have to click OK on... then I have to shut down the SQL Server to stop them). I did some searching but found nothing about. Anyone know how to fix it? ...more >>

Hi all I got the following error in event view applicatio Event Type: Erro Event Source: Microsoft Searc Event Category: Indexe Event ID: 703 Date: 2/20/200 Time: 10:10:12 A User: N/ Computer: xxxx Description The Property Store <d:\MSSQL\FTDATA\SQL0000700005\Build\Indexer\NlFiles\> ...more >>

I can now search the properties and content of the Web using Indexing service via a linked server configure in MSSQL2K. how do i pull the exact phrase and display in highlight the hits that i found. Like if your searching the browsed file in IE and highlighting what you looking for. *** Se...more >>

Hello, I have a problem with enabling my database for full-text indexing. Every time I run sp_fulltext_database 'enable' I get Server: Msg 7609, Level 17, State 2, Procedure sp_fulltext_database, Line 46 Full-Text Search is not installed, or a full-text component cannot be loaded. ...more >>

I assume the answer to my question is going to be NO, but I figured I'd ask anyway.... Can you set the Full Text Search feature of SqlServer to run on a separate machine? It seems to be stealing a lot of resources away from my DB, and I'd rather put it on a machine without so much processor l...more >>

Hello I have to rebuild a FT catalog with about 1.3mio records. Now the problem is, when I make this on the system (it's a live system), it just takes too much time, slows down the database and for beginning it clears all records. Is there a way, to rebuild a new catalog to a different locat...more >>

I have what I believe to be a bizarre scenario. I have a series of databases that I've backed up and restored onto another machine. However, the full text catalogues were not included in the backup...should they have been? I see that the catalogues are actually stored in the folder MSSQL...more >>

Hello there, Is there a way to instruct FTS to use this: .... WHERE CONTAINS(*,'Foo1 OR Foo2 AND Foo3') as this: '(Foo1 OR Foo2) AND Foo3' without the use of ( ) ? most of my users type it without ( ), and actually getting- Foo1 OR (Fo2 AND Foo3) Thanks! ...more >>

Hello, When doing full or incremental population the gatherer process sometimes = just stops. The mssearch service still works, full text queries still = return results. I notice this by observing the performance monitor. = The population I setup proceeds normal for 1 hour, 2 hours or so, a...more >>

Hi, In Swedish it is _very_ common with so called "composite words". Example: "Cat" is "katt" in Swedish. "Food" is "mat" in Swedish. Thus, "Cat food" is "kattmat" in Swedish. Now to the question: Is there a way to have Fulltext Indexing to recognise composite words so that when I search fo...more >>

I have been searching for an escape character or a way of escaping double quotes that are actually in a string that I am using in the contains predicate. Here is an example select * from table where contains(field, '"he said "what is wrong", that is what he said"') I need the double qu...more >>

Can someone please help me I have one table which I need to search multiple columns on The table looks similar to thi id Category Descriptio -------------------------------------------------------------------------- 0 Gardening Equipment ...more >>

The crawl seed <MSSQL75://SQLServer/75d7831f> in project <SQLServer SQL0000500005> cannot be accessed. Error: 800700e9 - No process is on the other end of the pipe. . The crawl for project <SQLServer SQL0000500005> could not be started, because no crawl seeds could be accessed. Fix the errors...more >>

Hi all. Has anyone heard about this software for SQL databases. As I can see this is what lots of my customers want and of cause I want faster searches. Is there anything the SQL Server 2000 developers are missing og is there a catch somewhare. Any comments out there? http://www.imptechnology...more >>

Hi, Can anyone tell me if there is some package wich allows full-text search engine to support portuguese words and forms? We portuguese have some special characters like 'ç' wich are can be used in a word but when searching the net we usually don't use the 'ç' but the 'c' so full-text engine ...more >>

Today we discovered a file on the C:\ folder of our SQL server (SQL 2000) called SQLFTQRY.TXT that is over 2 GB and growing by the second. Something seems to be running out of control, can anyone shed some light on this? What writes that file, and why does it go to the C:\ folder? We have ple...more >>

Dear All I cannot receive result by writing a CONTAINS query. My query is like contain("22", column). For some normal words, the query is fine. But for some value like "22", the query cannot find the result. Please help ... ...more >>

I am working on a project for my company. I am setting a flag when an error occurs in the data. My "source" field can contain any characters in the standard ASCII character set, but I want the flag to set when an extended character (ASCII code 31 or less, or 128 and above) has been found. The ...more >>

I've created a full-text index successfully on an image datatype. The item count is the number of rows I expect and the unique key count is about at 1508. The unique key count is lower than I would expect for the html documents if they are being indexed correctly, but at least something is being i...more >>

We are recovering to a test server using sql 2000 sp3. Even though both machines have the same service pack they both are showing a different version number. We want it to be showing 8.00.818 but instead is showing 8.00.760. It will not let us restore the database due to the different version number...more >>

I don't know if I should post here or aspnet community. If you know an answer to this, I'll be much appreciated. (SQl Server) I created a table for full-text search. It has an image field to store my html files and a field for extensions. However, when I retrieve data from SQL Server, I don'...more >>

Microsoft SQL Server 7.00 - 7.00.961 (Intel X86) Oct 24 2000 18:39:12 Copyright (c) 1988-1998 Microsoft Corporatio Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 2 I'm having trouble populating a full text catalog. Everytime I start population, item count is 0 and there are "c...more >>

The answer to this may quite simply be no, but I would like to find the actual word lists that FTS produces and thus stores as the output from the population process as part of fts. My thinking is that by definition FTS must interrogate each column that is to be included and determine what each ...more >>

I have imported another database onto my existing SQL 2000 database and found that my Full Text no longer works. Even though I have rebuild the catalog, whenever a full text query is run no result displays. Why is that? What do I need to do in order to have Full Text work? *** Sent vi...more >>

Does the new reporting services require that you add users on the back end or do you create the requirements at the time you create the report?...more >>

I performed the following search using MS Query Analyzer (SQL 2000): select * from kc_rawtext where contains (value,'"Account"') however, all of my search always comes up empty/no result. Is CONTAIN working in SQL 2000? When I try the same type of search using LIKE, it works: select * f...more >>

Are there any log entries made anywhere when the catalog population is executed? Thanks, Rg ...more >>

anyone know why sql server disabled my New full-text catalog? I am trying to create a new full-text catalog but when I Server--> database and right click the function "new full-text catalog" is disable y?? thx~~ ...more >>

Hi FT guys, We're working on an application based on FT queries but we have a problem : The DB is about 1.500.000 record and when we make search with a generic keyword 'car*' by example (occurs 60000 times in the DB). the query takes about 4 minutes ! When we limit the nb of rows in the con...more >>

I have reposted this question because my machine crashed during submittion. If this question appears twice then sorry! My system is Windows XP Pro SQL Server 2000 - SP3 VS.NET 2003 I am trying to generate a full text index on a table but I am getting 'Interface not supported' errors al...more >>

Hi, Is there anyway to use a different set of noise.dat files for different full text catalogues? I am using SQL Server 2000 sp 2. E.g. I have a project (project 1) where I would like to remove the numbers from the noise word lists, however if I have another project installed (project 2) on...more >>

Hi, could you please put me on the right track!? Right, the problem is: I run a query (using CONTAINS) on an indexed SQL Server 2k databse table. I need to allow my client to search on phrases containing single letters i.e "Mel B", "Mel C". The query results I get show that the search is ignorin...more >>

Hello, I´m developing an application in ASP/ASPX, with: - MS Windows 2000 Server (All updates until this date are applied). - IIS 5.0 - SQL Server 2000 (SP3) - Adobe PDF IFilter v5.0 When I send a PDF file via http to database, file is indexed inmediately, with independence of the...more >>

I would like to gather info on how long it takes the catalog population to complete. Any ideas on how to retrieve this data? Thanks, Rg ...more >>

On a SQL database, can indexing be performed while specific tables are encrypted Thanks...more >>

I have to FTS 50+columns across 3 joined tables. The search returns the appropriate result-set, however I need to know which columns contained the search criteria. So while my Select will have 50+ columns I need to idntify which casused them to be returns. We're using Microsoft SQL Server 2...more >>

SELECT @@versio SELECT @@languag Microsoft SQL Server 2000 - 8.00760 (Intel X86).. us_englis I like to search a modern terms like 'e-business' 'e-commerce' and in spanish 'e-salud', 'e-administracion'.... but SQL Server make the word breaking with this terms and if you search e-business yo...more >>

how do i search the index server from the query analyzer of from sql server 2000. are there any configuration that i need to do to sql server 2000 and index server...more >>

Does someone out there could give me a starting point how to access the WSS full text index with asp.net ...more >>

I am using FTS with the CONTAINSTABLE predicate, on a Win2K/MSSQL2K box. What I want to do is: If a user enters more than one word with no "" or boolean operators, treat the entire string as an OR statement. This is with maintaining the functionality of CONTAINSTABLE. So if I as a user p...more >>

When I query SQLServer FT Index using CONTAINS clause for a value that contains a "/" I get unexpected results. For example when performing a search for a product number "WIR 3/0THHN" I also get products "WIR 2/0THHN" and "WIR 4/0THHN" in the results of the search. Can anyone suggest a ...more >>

I just installed (new install) Win2003 Standard Server edition. Installed SQLServer 2000 with SP3. I am unable to start the MSSearch service. Error I get: Faulting application mssearch.exe, version 10.145.3914.3, faulting module mssearch.exe, version 10.145.3914.3, fault address 0x0000417c...more >>

i am using full text indexing on sql server 2000. indexed one column "path" of the table "data" where the column "path" contains the path of some word documents. Whether it is possible for me to search the content of the corresponding document by taking only the path from "path" column?? ...more >>

I have a table with 300k+ entries containing job titles I have a full text index on this field. The query is SELECT COUNT(*) FROM JobTitles WHERE CONTAINS (JobTitle , ' "Developer" OR "Programmer" OR "SOFTWARE ENGINEER" ') -- whitespace added for readability and this returns 66229 e...more >>

Anyone ever encounter this error during full text indexing a table with MS Word 97 docs in it? The docs are stored in image fields. Error fetching URL, (80041201 - The object was not found. ) Most importantly, we're not using Sharepoint so please do not refer us to the MS doc on tha...more >>

Hi, I have fulltext indexed several columns in a table, how do I search two or more columns but not all the columns? Thanks...more >>