Hi. I have a problem with setting up a fulltext catalog so that I can do fuzzy searching. When I use "EXEC sp_fulltext_database 'enable'", there is no problem. But when I next use "EXEC text_catalog 'Cat_Address', 'create'", I get the error "Execution of full-text operation failed. T...more >>

Hi! everybody, I found it's not allowed to build full-text index on a table which has a primary key composed by more than one column. Does anybody know the way to workaround? My table is a child table so it must have two columns in primary key. I'm using SQL-Server 2000. Thanks for you...more >>

I've got a problem with the XML iFilter on SQL Server 2000 SP3 running on Win2K Enterprise. I did the following: * I created a table containing an image datatype and added a column (char 3) with xml in it. * I added the regsvr xmlfilter.dll to my registry and rebooted the system (you never k...more >>

(SQL Server 2000, SP3a) Hello all! On regular intervals, we're seeing a lot of OS page faults on our Production server (Windows 2000 Advanced Server), and have traced part of those symptoms to the MSSEARCH.EXE executable. The box has 4GB of RAM, with SQL Server capped at 1.5GB. We've got...more >>

I have a standard full text query running for a search engine on my database's articles, but the results do not seem completely logical, the AND, OR, NOT operators dont do anything, how do you use them in a full text search? (implementation wise), or what is the best way to implement a full text...more >>

Hi, We are using Ful Text indexing to index a long data string as image data. The data is delimited with field markers such that id numbers will be embedded in the string as |some data|09765665|some more data| when seaching for the complete string 09765665 the record is returned as ex...more >>

I am using Windows 2003 server with SQL 2000 MSDE. Iam trying to implement a fulltext catalog on one of my tables. 1. MSSearch service is running 2. I followed the full text catalog wizard and implemented most default options on the desired table. 3. I did a full population of the catalog a...more >>

Could someone please send me a copy of Hillary Cotter's SearchPage.htm file and instructions to use it? All copies of this file posted on this forum seem to be garbled. Thanks a lot, Tony -- Posted via http://dbforums.com...more >>

Greetings I'm working on a large and growing database of security alarms. I'm looking at ways to mine the data that allow me to group sets of records with similar values. For example "device-xyz", "high cpu load from device xyz 95% > threshold of 90%" "device-xyz", "high cpu load from...more >>

Hi everyone, my full text isn't working any more (the services related are). It did work some time, but I'm not really sure when it stoped working. My SQL is version 2000 -8.00.818 (which I think is SP3a). Maybe it stoped working when I installed the latest service pack on the SQL. Who knows? ...more >>

Hey all, Running into a jam with a full text search we are running. Everything seems to work fine except when someone tries searching for a series of single letters (ie: "J R M"). The information I have: Error: -2147217900 - Search on full-text catalog 'FullTextGG' for database ID 9, ...more >>

Hi all! Please - I really hope someone can help me... As part of a document management tool, I am trying to read and write files (of varying content - some txt, bmp, jpg, doc, xls, xml, etc) to and from the windows filesystem and a SQL database. The file content is stored as an ntext in a...more >>

Hi, We've developed an asp.net web site which uses SQL Server's full-text search facility. On our development server it works fine with all the characters but on client's server it works with Latin characters, but when at least one other (Lithuanian and Russian to be exact) is present, it fail...more >>

Hi All, I want following Results from a query without using any tables or cursors month_id month_nme ---------- ---------------- 1 January 2 February 3 March 4 April 5 ...more >>

Could someone advise what the prefered/best method would be to host/setup for the National Do Not Call List? There's two options for download.... xml and flat text.... I need to make the list searchable, would prefer via intranet site.... tried to import into xls file... after about 65,000...more >>

Hi, I'm trying to use FTS on a table with approx. 60.000 customers to find similar entries, based on either lastname and zip-code, or street and zip-code. Now FTS is working and returns results when searching like this: WHERE ( (@nn <> '' AND @zip <> '') AND ( contains(KU.Nachname,...more >>

Hello Developers, can anybody help me with indexing Html-Text in ntext-Fields. I Could not change the field-type into image, so i can't use the standard way to say sql-server which filter to use. Is it possible to change SQL-Server in this way that it always uses nlhtml.dll instead of que...more >>

SQL SERVER 2000 Full Text Newbie here. I have looked & searched many places for info that actually compares and contrasts what these two operations do. I can find HOW TO do each, but not WHEN TO do each. I keep morphing my WSS SharePoint sites and moving lots of documents around, also m...more >>

Folks, I need to do a full population of an FT Index from a table with about 240,000 rows. I am dong this on an enterprise spec server. My window of time to do this is limited and I need to do it as quickly as possible. Currently, this seems to take hours! Looking at task manager, the FT Se...more >>

Hi All, Full text catalogs fail to populate on server running SQL Server 2000 in a Fali-Over Cluster environment . The problem appeared after an upgrade to SQL Server 2000 SP3. I have tried suggestions relating to similar problems but none have worked. Microsoft SQL Server 2000...more >>

I am trying to create a full text index on an image column in a table with only two rows. The first is an integer field which is the primary key. The other column is the image field (the one I want to index). I receive a message which states there are no columns to index. I am very new...more >>

Hello, I have created the following database table: CREATE TABLE [dbo].[tblProfiles_Ap] ( [lngProfileID] [int] IDENTITY (1, 1) NOT NULL , [strXML] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [strNormalizedXML] [ntext] COLLATE SQL_Latin1_General_CP1_CI_AS NULL , [strFilename...more >>

I have some questions regarding search implementation on a site I'm working on. I'm trying to decide how to design my database so i can optimize for searching. I'm planning the site and the database so that multiple sites can all run off one database. My dilema is that if use one database i will ...more >>

Hi, Im trying to build a search system that will return results based on the join (or merge) of two full-text search queries. The core tables are Companies C, Categories CAT, CompanyCategories CC and Keywords K. CAT has full-text search enabled on the category name (indexed by ID). K ha...more >>

What is the sequence of making query in SELECT * FROM Product pp inner join CategoryXProduct pc on pc.ProductID = pp.ProductID inner join dbo.TN_Category cc on cc.CategoryID = pc.CategoryID INNER JOIN FREETEXTTABLE(Product, FullIndexField, @FullIndexField) AS kt ON pp.Prod...more >>

We have a custom IFILTER which define some new properties in a custom property set. Using filtdump and the Computer Mangement Console we have verified that the new properties do exist and are added to documents. However, Sharepoint 2003 does not know of our new properties (even after we have ...more >>

I'm Getting the above error in the evemt logs after installation of SQL SP3 on our cluster. It looks exactly like KB article 817301 but I've tried the workarounds mentioned there without success. Does anyone have any thoughts or suggestions please. Many Thanks Tom...more >>

Hi, I've recently installed Full Text Cataloguing on a SQL Server 7.00.1094 Unfortunately when i run a search on a catalogued table i get the following error... ---------------- SELECT COUNT(*) As totalrows FROM CONTAINSTABLE(docs, *,'Toby') Microsoft OLE DB Provider for ODBC Drivers error...more >>

Hi, I have created a few tables in the 'msdb' database in SQL Server. Now, I have created a new database in SQL Server. I need to reuse some of the tables I already have in the msdb database. However, I am unable to do a copy of the tables or the Database Diagram or the Stored Procedu...more >>

We have a table enabled for full-text indexing. Incremental population is scheduled hourly but we were seeing timeouts during this period. In investigating, I read that a timestamp was required on the table for incremental population to work, we were actually running a full population eve...more >>

I am using contains to do a search based on what is entered from a web screen. The query keeps returning 'A clause of the query contained only ignored words'. How can I find these 'Ignored Words' or does SQL 2000 keep them hidden? Can I update them to remove ones I would like the user to seac...more >>

I am trying to troubleshoot a poor performing query that has a contains clause. I open the Estimated Execution Plan in query analyzer and it is blank. How can I get the plan to show up? are there best practices to get slow fts queries to run faster? Here is the query I am running: SELEC...more >>

Where can I look to find out which Windows Sharepoint Services document is throwing this error (below)??? Why would some "doc" documents throw this error, others are indexing & searching okay? -Robb Event Type: Information Event Source: SQLFTHNDLR Event Category: None Event ID: 2001 ...more >>

Hi, I want to modify a file of noise words but i can't because other process is using it. I'd sotoped the server but is not the solution. How can i do it? Thanks, Joaquín. ...more >>

Hi everyone, is it possible to uninstall full-text. I can't do it from the setup CD. Thanks a lot, Ivan Mckenzie ...more >>

Is there a way to determine the number of hits the query received in the document indexed? I think this would be similar to the RANK column when using CONTAINSTABLE, except something like a HITS column? Thanks, Dan ...more >>

Hello I'm running Win2K SP3, running on an active-active cluster. After the install, I removed Full Text because it was not necessary for the hosted DB. However, now I need to run full-text, and when I re-added the resource, I'm getting failures of the Search service. I have modified the permission...more >>

Hello I understand that when a full text query is run using containstable, the MSSearch service returns a table of keys for all records matching the containstable criteria, then the SQL WHERE clause is applied to that recordset. My question is, does CONTAINS work in the same fashion? Exa...more >>

sql server 2000 sp2 on Win 2000. Full Text Search has been installed, but when I run the procedure sp_fulltext_database 'enable' I get error 7635 "The Microsoft Search service cannot be administered under the present user account". I'm logging in as SA and the statement works fine on my ot...more >>

Hi there (this is my first time on this group so be gentle :-)) I have experimented with the HtmlProp IFILTER from Microsoft SDK\Samples\winbase\indexing\HtmlProp (which decorates the standard html filter). I install it using regsvr32 and everthing works fine, as can be tested by writing fi...more >>

Hello I am working on a database that has audit tracking tables that have been designed in a peculiar way. Initially there will be only one table - audit1. When this table grows over a "configurable" limit, a new table audit2 is supposed to be created. And from then on the system should use the...more >>

Hi, It's possible this query? SELECT ... FROM... WHERE CONTINS(table.col1, table.col2, 'text') or i've to do: CONTINS(table.col1, 'text') or CONTINS(table.col2, 'text')? I don't want to use all columns (*) Thanks, Joaquín. ...more >>

Greetings All, A couple of questions: (1) Is there a maximum size for full-text index files on a server? There appears to be a reference in an MS Whitepaper on FT indexing suggesting that the total size of *.ps1 and *.ps2 files cannot exceed 2 GB, but that just doesn't sound right in the li...more >>

Hi all I recently made a database with large size(2GB) and large Fulltext catalogs(1.5 GB), and it take a bout 50 hours. so, can i transfer my database whit all the FT catalogs to another server and computer?(Becuase i haven't enough time to repeat this jobs, indeed in other computers m...more >>

Hi, I am trying to implement a full text search on one of my tables in my database which holds articles for a website, and I have never implemented a full text search before on sql server. are there any articles on how to do it or tutorials out on the web that are really good? all i have found...more >>

Hi I have written a full text search application which works fine except when users inadvertently enter noise words. Is there a way of detecting within a stored procedure if a particular word is a noise word? Alternatively, is it possible to use custom noise word files for particular...more >>

Hi all Is there any way of opening a word doc (or modifying a temporary version before opening) and highlighting words found in the document. It is part of a search facility so when people search for a string I would like their search strings to be highlighted when they open the documents. ...more >>

I am using SQL SERVER 7.0. when i am trying to add a new Server in the Enterprise Manager i am getting an Illegal Operation error"mmc" When seen in the details it shows error in vga.drv. the display adapter used is "Standars VGA DIsplay adapter" System Cofiguration is as follows: p-III...more >>

I was buldingout my first full text index on a 20m row table. I was surprised to see that after a couple of hours that the status went from 'Full population in progress' to 'Paused'. I have plenty of disk space, memory, etc. what caused this to happen? how do I restart the build? thanks!!...more >>

I have a table containing an Image field which is full-text indexed. There is a timestamp column in the table named FTSTimestamp. The table only has 36 rows in it yet it takes over 15 seconds to perform an incremental population exec sp_fulltext_table 'mytable', 'start_incremental' eve...more >>