I have three tables: Products Table PID PName PType Linking Table LID PID CID Customers Table CID CName CPhone I am trying to make a single statement that will give me all the customers that haven't bought a certain single product so i can make a list of people to c...more >>

Hi!, I have partitioned my tables vertically based on year (1939 - 1995). I have full text indexed all these tables and populated them into one single catalog. Now, what query should i use for querying all the tables(1939-1995). I need to use either contains or containstable. urgent help ...more >>

Hi There. I have a database table that I would like to integrate a full text index on and have the table automatically rebuild the index on each insert/update/delete. I think I have a good idea on the methodology from reading through the posts, but I cannot get it to work on an automatic basi...more >>

(SQL Server 2000, SP3a) Hello all! At my company, we have a database with 12 Full-Text Catalogs defined. Some of these FTCs are apparently defined to use automatic change tracking (CT) and others use incremental population via scheduled jobs. Is there any way to determine which of these FT...more >>

hi, when i try to start the Sql Server Agent it gives this error message and could not start. "An error 1069 - (The Service did not start due to a logon failure). occured while performing this service operation on the SQLServerAgent service. Plz tell whats the reason behind this, whi...more >>

I need to disable noise words from my full text index is this possible? I have a 6.6 million row database with a full text index column varchar 128. The column is used for business names and proper names. Business names could be A & A Automotive or Your Next House etc... Proper Names could be ...more >>

Hi, I am building a search engine for PDF documents for a website. I have both Engish and Arabic PDF files mixed up together. The things what I already done are as follows. 1. Created a table with an image column and doctype column. 2. Saved all pdf documents in binary format(Arabic and Eng...more >>

Does anyone know if a timestamp column needs to be added to the table I would like to do an incremental population on? The BOL doesn't specifically say if the timestamp is an internal value or not and my testing has shown (on a table without a timestamp column) that doing an incremental populati...more >>

Do I really have to call in and pay to get this fix?: http://support.microsoft.com/default.aspx?scid=kb;en- us;814035 Has anyone else already applied it?...more >>

Hi, We have a client using FileMaker Pro. They have in their table a field which contains a large amount of text. They have reached FMP's limit of 2gb data storage and I've recomended upgrading to SQL 2k utilising FT searching. I've imported their 250,000 records and created a FTC. ...more >>

hi there, i m making a search engine using asp.net, sql server 2000 sp 3a, xml. OS is windows 2003 standard server. actually main data is present in xml files and when those xml are uploaded i try to put important field data(tags) in sql server for searching. those fields tables are full tex...more >>

Hi, I have a requirement where in i have to search for duplicate documents in my folder. I copy the contents in the document to a TEXT column & i enable FTS on this column. Now i want to check for the content in one document being present in another document (Maybe with a few minor changes)...more >>

Hello, Can someone give me an estimate time to populate a full- text index for a 9GB size table in SQL Server 2000. (I am sure that the population is going to depend on what kind of the hardware we have.) Thank you so much! -Mitra ...more >>

How do I use wildcards with CONTAINS? -- This gives me good results DECLARE @SearchTerm varchar(50) SET @SearchTerm = '879123' SELECT OrderNo FROM ItemStock WHERE CONTAINS (OrderNo, @SearchTerm) -- I tried changing the SET statement and I get no results with these attempts SET @SearchTe...more >>

What are the hard drive requirements on an average table if it has a full text index index. ...more >>

Hi, The query pasted below SELECT CAST(copy.copyid as VARCHAR(50)) as copyid FROM copy,story,brief,link_copy_issue,brief_issue WHERE CONTAINS (copy.*,' weight AND loss ') AND brief.briefid = '96EE6D61-D70D-47B9-82C2-F1105A0A863C' AND brief.briefid = brief_issue.briefid AND link_copy_issu...more >>

I finally got my local SQL Server setup and created my first catalog. That catalog has 3 tables in it. I'm just trying some simple searches without success. -- This query syntax checks out OK, but yields no results. SELECT OrderNo, Description FROM Stock WHERE FREETEXT(Description, 'Amplifie...more >>

I have been searching through the MSDN library for instructions on how to add/create custom filters for full- text indexing of additional file types in SQL 2000 so it will index other files types, such as .aspx, etc. Any help with that will be much appreciated....more >>

Can someone let me know if using UPDATETEXT can cause a memory leak in SQL Server when using FULL Text Search ? Thanks ...more >>

hi all, we are trying to take advantage of fulltext indexing in our product by making searches faster and more accurate ..., we implemented it with good success and our performance data also indicates that page response time and improved a lot on search pages .. only one problem now, the F...more >>

hej hej! We have to build about 10 different FTS on different tabels with up to 5.000.000 rows each on SQL 2000 Enterprise Edition - SP3 (Win2000 cluster environment). Because of an insufficient disc storrage array we can only use 10 hours during the night to build up the primary full populat...more >>

Is there any way to get MS SQL Server 2000 to keyword search Outlook files that have been imbedded into an attachment type field? We can search DOC, RTF, TXT, and PDF files but not MSG files. Thanks....more >>

Hi: When I leave my computer unattended and I try to connect to SQL 2000 with a Visual Basic 6.0 application, I get the following message: [Microsoft][ODBC SQL Server Driver]Can't generate SSPI context (translated from Spanish) it's the only machine that has this problem, and it di...more >>

I'm having trouble with our cluster after a fresh install. When we failover to the second node, full text indexing does not work. It works fine on the first node. The catalog appears to be updating but I see this in the event log: ------------------- Event Type: Information Event Source: ...more >>

Ms search failed to install (there was no indication of this during the install)during a new SQL install. Is there a way to "install" ms search after the fact or do I need to re-install SQL? If so, any reccommendations on the second go around would be appreciated....more >>

I would like to generate a distinct list of words in the master index as well as each words frequency. Is there any way to generate this list via the SQL dialect?...more >>

First of all if there is a better news group to be posting this in please let me know. Let me preface this by stating I am not a DBA nor to I pretend to be. I took an SQL Server 2000 with transact SQL 101 class, so that's the extent of my knowledge I use an application called Altiris which...more >>

I'm trying to create an FT catalog on my site. My intentions were to create a 'Do You Feel Lucky' search box. The user could search all database data and hopefully get results. I have 2 tables that share a one-to-many relationship. STOCK and TITLES. I have no problems with STOCK. It has one uniq...more >>

I'm still fairly new to the fts engine. However it doesn't seem overly useful unless you are perhaps relying on it's more sophisticated language features. I'm thinking of just going back to queries using "like '%searchterm%' ". Anyone have any thoughts on peformance and other pros/cons of using one ...more >>

I read a couple posts on the '#' sign being an ignored word that you can't make not ignored by removing it from the ignored words files. Anyone know if there is a list somewhere or an easy way to get this info out of sql server thanks cp...more >>

Hello, I have posted before regarding a problem we are having installing the Full-Text Search engine on a SQL server. I was instructed by a posting in this news group to basically remove a "tracking key" from the registry and then re-install the service and then re-install SP3a. The above ...more >>

While running a stored procedure it errors out on some occations. Proc is doing a select on a Column which has full text enabled . " Server: Msg 7619, Level 16, State 1, Procedure GET_PROSPECTS, Line 96 Execution of a full-text operation failed. A clause of the query contained only ign...more >>

Hello I would like to find words like 'meteo' and 'm=E9t=E9o' in the=20 same fulltext query. How can this be done?...more >>

Dear All, I have design my own mechanism for searching the article and resource(images) from the Microsoft Content Management Server 2002 by using Full Text Service of Sql Server 2000 in English Language. I need to search the article and resources in Arabic as well. If any body knows how to searc...more >>

H I need to get the table name(s) and the column name(s) present in a query before it is executed against the database. Are there any built-in functions (in SQL Server or in C#)? I came to know about "ODBC minimum SQL Grammar" from MSDN. Anyone knows whether it'll serve my problem TIA Arrun S...more >>

I'm assuming it's OK and possible to create a catalog on a view or stored procedure, correct? That said, which is better, a view or stored procedure? I have 3 tables that I want to combine some of the fields and do a full text search. thanks! ...more >>

Hello Everyone, Back on Dec 18, i had posted my question in regards to the error message i was getting using Full-Text Search: "[ERROR] archives.display_results(Execute new Query - SMTP) : java.sql.SQLException: [Mitra2000]Search on full- text catalog 'CAT_Mime_Content' for database ID 7,...more >>

Hi, We are trying to (full-text) search across multiple fields using CONTAINSTABLE. Let's say we have a table in our database (table name: Catalog) which has three columns namely: DOCN ==> Primary Key field1 field2 and we would like to search the words cat and dog The qu...more >>

I've read the posts on noise words and figured out which noise file my server is using, edited it, etc. Now, I search for "the" and don't get any results. My question is on when the search service builds the indexes does it use those files to figure out what words it shouldn't index? For example, if...more >>

The SQLS sample DB has the string 'Mexico City', where the 'e' is a unicode character (8bit = 233). When I search for 'Mexico City' using contains, I do not find this record (just like using this string in the where clause). So far I have found out how to specify this uniquely in a 'where cla...more >>

Hi, In my application, information related to the uploaded files are stored in Sql Server. During the content search, i have to query both sql server and index server. I am trying to use the 'OpenRowset' function of Sql Server to query the index server. But this function doesnt work i...more >>

I have a SQL 2K Database with OLE Objects (actually word documents inserted with the MS Access' right click - insert object... method) stored in image type columns. I need to FTS the word documents, but they won't index b/c they are inside the OLE "wrapper". Is there a way to punch through this "wra...more >>

Hi, I was trying to find out if thesaurus and stemming is supported in the search functionality provided by windows sharepoint services to assure a client. I was told that that functionality was actually supported by sql server. But i got a surprise when some one told me and point me to kb 309...more >>

Hi, I hope this is not entirely foolish - my SQL environment is: Microsoft SQL Server 2000 - 8.00.194 (Intel X86) Aug 6 2000 00:57:48 Copyright (c) 1988-2000 Microsoft Corporation Developer Edition on Windows NT 5.0 (Build 2195: Service Pack 4) I'm building an aspx page to search ...more >>