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?

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).

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

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.

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

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

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

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

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 .. ...

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.

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

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

I'm trying to access an Indexing Service located on a remote machine usin
the distributed query functionality of MS-SQLServer
On a newsgroup on Goggle I found an old article in which it was describe
a configuration that I replicated but with no lucky

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:

CREATE Table MyTable(
   ID    int,
   Title    varchar(1000)
)