Do i need to populate the Full-Text catalog and Full-Text Index both in
order to get the most updated data??? I thougth all I need to do is to
populate the Full-Text Index, if so, what is the reason to populate the
catalog, too????

I am in the process of evaluating the existing Implementation of Fulltext
Index in our product(sql server 2000).We have full text index (text type) in
a table with out timestamp column.The existing settings for creation and
maintenance are ,

 I have a database that has about 100 tables.  How can I find out which
tables are full-text indexed?
Thanks
Ed

 Can one Full-Text Catalog apply to more than one tables???
 e.g.  I need Full-Text Catalog in Northwind that needs to apply to
Customers and Categories table, should I create one Catalog for two tables or
one catelog for each table?

Hello!  My query skills are in need of some help.  I've simplified my tables
in order to explain what it is that I'm trying to do.  I need this to create
dynamic checkboxes on an asp.net page and to have the checkbox values set as
the tables are drawn dynamically.  Anyway, here ...

I'm trying to evaluate between using MS Sql server based full text search Vs open-source full-text search for our core product.  Does anyone know of any previous benchmarks/comparisons between these two approaches?  Appreciate any reply.

I try to execute the sp_fulltext_catalog procedure from an application which
has only limited rights on the db. Is there any way to execute this
procedure without adding the account to the sysadmin or dbowner server role?
It is very important for securtiy reasons to give this ...

I am using Windows 2003 Server. The VPN works fine, but I want to FTP
through the VPN so the connection is encrypted.  The problem is each of my
IIS sites has a real Internet address specified, w.x.y.z.  So when the VPN
comes up using a private IP, I can't connect to any of the FTP ...

I'm searching a column which holds XML data in a varchar field.  
When I search on reference 'XX12345678' I get results, but when I search on
'XX12345678/1' (the full reference number for my application) I get no
results.  

I am searching a text fields, I have every setup already and I am able to do
CONTAINSTABLE and FREETEXT... When I use weight the numbers dont make any
sense.  I really would like to be able to specify a value for the my keywords
and also determine what words were found when I run ...

If I have accented characters in my table which is full-text indexed then I
cannot search for the corresponding non-accented character. e.g. I have the
character "é" in my column (which is nvarchar), so searching for "é" comes up
with results because it is actually entered as "é" ...

we are using fulltext indexes computation on Production Server.
MSSEARCH eats between 20 % and 40% in a regular manner.
It picks up to 40% then goes down to zero but some secondes later will climb
again to 20 and up to 40%

I have searched high and low for an answer to this question. Please
tell me that it is a simple process....!
I have created a website in English using SQL 2000 as the database.
Now I have just launched the same website in French using exactly the

I have an issue with a 64-bit clustered installation that I've just
completed, obviously the management tools can run on the itaniums and
I've put them on a 32-bit server on the same LAN.
My problem concerns creating the full-text indexes that I used to have

I have a full text index which took 20 hours to complete the full population. in case of a problem i don't want to repopulate if spending 20 hrs.
Is there a way to backup the Index File structure and resore it using a software like windows backup. Or just copy the file structure ...