Hi there, Does anyone know how I go about upgrading from SQL2000 standard edition to SQL2000 enterprise edition (I need to install full-text searching). Is it as easy as slamming in the enterprise edition CD and upgrading, or are there any known issues? Thanks Cammie....more >>

We have a problem with implementing Full-Text capability. Here are the details about our system: We have: 1) Windows 2000 Server 2) Windows SQL-Server 2000 Server with SP3a 3) And Full-Text component installed while installing SQL- Server 2000. -- We installed SQL-Server 2000 with a user...more >>

hi, I have problem with my current table design in implement the full-text search. Since the existing table doesn't have single unique field(my existing design is composite key field, which means 2 field combine together as unique). how to do create the index full-text search. The system is r...more >>

What is the specific function of NEAR? I'm indexing across 3 text fields and expect hits for 'white NEAR black' and only getting a hit when the two words are in the same field, but not if they are spread across two of the fields. How NEAR does the other word have to be? ...more >>

Hi, May i know what's the requirement to implement full-text search? Do FTS run under Windows XP and Windows 2003 environment? Thanks! ...more >>

Hello everyone, First of all, my name is Hugo. I'm having a very strange situation when performing an Incremental Population. I have a Table "A" with a timestamp column, and a catalogue over three columns of "A". This table has only 100K rows (a subset of our production environment, with ...more >>

I am running SQL Server 2000 SP3 on Windows 2003 Server. I have been receiving full-text failures on queries such as this: select * from table where contains(column, '"AT&T"'). If I remove the "&" it seems to return only the ATT entries vs. ATT and AT&T entries. I can take this same query ...more >>

John, Thanks John! It's very great example. I'm using SQL Server 2000 FTS. 1. May i know what different between CONTAINS and FREETEXT? eg. select * from pub_info where CONTAINS(title,'booktitle') and select * from pub_info where FREETEXT(title,'booktitle') Its returns same resul...more >>

hi... i'm newbie here... can i have a sample program for fulltext search. thanx! ...more >>

Hi, I have a SQL Server 2000 cluster, sp 3 in w2k. When the catalog is reindexed, some documents appears in FTDATA folder. If I delete the documents, then they reappear in the next indexing. I'm thinking about to schedule a batch that cleanup this folder, because I have the FTDATA in t...more >>

CREATE Table MyTable( ID int, Title varchar(1000) ) I trying to find all records that contains any of the words : "one," "two," or "three" in title column. I need to order the result by row that contains most of the words. Any help will be appreciated. Thanks, Rake...more >>

Hello everybody, and thanks in advance for your help. Well, I have created a full-text index in a table with about one million records, indexing three fields. To start with, I created it with an incremental filling programming once a week, saturday night. But the problem is that without an ...more >>

I am very new to the freetext searching and have not been able to decipher some of the documentation steps in making FreeTextTable work. I have a table with a primary key of "KeyID", and my search index is created on varchar fields of Problem and Cause. I also have a field called WorkOrd...more >>

When I start the population it doesn't appear to stop. I don't think it even starts. What I mean is when I right-click on the table and choose start full population, I go back to check and the only active choice is to stop the population. After 24 hours it appears to still be running (or trying t...more >>

'X-No-archive: yes' Greetings: I would like to use full-text searching to look over a series of fields. My stored procedure searches for film titles in a database. The only problem I encounter is when I look in VideoPersonnel -- First Name and Last Name columns. If my search is 'Alfr...more >>

Subject: A Student Needs Your Help with Research Dear All, I am pursing a Master’s degree from Monash University. Currently, I am in the final stage of my program. I am doing a research project examining the impact of Microsoft’s Reporting Services Product on the business intelligence ...more >>

Hello, i m using full text search .. but the problem is i want to present the result with very few results with the rank ... the rank as generated by the sql full text is only usefull when compared with the other ranks .. i want to scale it from 1 to 100.. any ideas on how to do this ... ...more >>

I've noticed that the CONTAINS function in the SQL SELECT statement has a strange behavior on XML. When I use a statement like: SELECT * FROM T where CONTAINS(dcxml,'pesca') where "dcXML" is the column name and "pesca" is the word I'm searching for, it only finds XML docs in the form of: ...more >>

Hi I have a table with 4 columns which are full-text indexed. I have noticed that certain words are not being indexed and therefore not returned in searches. I have also noticed that the position on the word in the column effects whether it is indexed. For example: I need to search...more >>

Hey I have a wierd SQL Server 2000 full-text index problem when copying between two image tables. I'm using Access XP as my front end and SQL Sever 2000 (with SP3a install) as my backend. I'm trying to parse and search resumes using the SQL Server 2000. I'm using a staging table to proof new...more >>

Hi, I'm indexing a single field on a table with 10 million rows in it, its currently taking about 48 hours to build. I've been looking into performance bottlenecks on the system and see that this delay is being mainly caused by MSSearch writing massive amounts of data to the FT Index locati...more >>

I'm writing a full text search website and I'm including a fuzzy search. Is there a way to retrieve a "word listing" of what sql server is going to use when I use formsof inflectional. So when the user types in invoice; I would get back invoice, invoicing, invoices etc; so I can highlight the poss...more >>

I am trying for the first time on this SQL server to use the FULL TEXT SEARCH. I can successfully use it on other similar servers. When I try to add a FULL TEXT CATALOG to a database I get this message when the wizard is trying to do the work: The Microsoft Search Service cannot be administere...more >>

Hi, this is kind of confusing me, and I'm not even sure I can do this. Let me define two tables for simplicity, [Query] and [FullText] [Query] - table of full-text queries id=3D primary key integer column query=3Dfull text query e.g. "word1" AND "word2"=20 [FullText] - my table which has ...more >>

Hi all, I Had installed an english platform with full text indexing enable. My data are French (with some accents for example). When I search with a CONTAINS Statement on my Data, SQL Server drops my accentuates characters. How can I resolve this problem ? What must I install on my platfor...more >>

Hello, Aplogies ifg this is the worng news group for this question. I have been looking in detail at the full text catlog in Sql server 2000. I have found some of the facilaities very useful but a very big disavantage for me is the wildcard seacrhing. You can only search ast the end of a w...more >>

I want to enable "Full-Text Indexing" in my Microsoft SQL Server 2000 database, except when I go into the SQL Server Enterprise Manager and click on the "Tools" drop down menu in the tool bar, the option "Full-Text Indexing" is grayed out (aka greyed out). I think I need to start a service nam...more >>

Hello I have this query which works fine, but I would like to order by rank, so i get most "correct" results first...... SELECT * FROM Questions WHERE FREETEXT(Question, @Keywords) OR FREETEXT(Answer, @Keywords) OR FREETEXT(Headline, @Keywords) TIA /Lasse ...more >>

We are just starting to use sql 2000 Fulltext functions and would like a local technical person to discuss concepts with. Thanks, John B...more >>

Hi I'm getting the message below when trying to query my fulltext index (see example code). I've researched on google and tried everything I could find, I cleared the noise word files, restarted the full-text service and rebuilt my indexes and I still get the message. I tried freetext instea...more >>

Can anyone recommend a good book or site on Full Text Searching which goes into detail about things like full text ranked search across multiple tables especially using phrases not single words? I find the whole thing counter intuitive compared to normal SQL ...more >>

Hello, I am learning the Full Text Search and Indexing services and it works great...so far. I can perform searchs on just about everything I need execept..... I have not yet figured out how to do a simple phonetic search. One of my document contains the word 'Hélène' (I am french) a...more >>

I have a sproc that accepts variables from an ASP page to process the search for the user. The user can choose 3 methods: 1.)Any Occurence 2.)Word/Phrase 3.)Exact Word/Phrase The sproc goes through some if statments to decide which sql statement to execute based on the meth...more >>