I just created a catalog in pubs includes table 'emplyee'.
How do I know the indexing population is finshed?

Any RTF filter can I download from ?

Do I need to download SQL Server 2000 service pack to get the full-text
search working ?
I am using Developer edition.

I cannot make the catalog active.
I tried both using T-SQL and inside EM in SQL 2000 but the status is still
idle.
Any rules I need to stick to? eg. what user login, authentication mode..etc

I tried to use change tracking (with background or update index
options) and incremental index.
Change tracking is very fast!! Better then incremental function.
But my query are very slow now, time to make a query is doubled!

I got SQL 2000 Developer edition installed on both Win2003 and WinXP.
However, by going into EM and created a full-text catalog using Pubs
database, I can only define the name of the catalog but there is no table
table for me to include the tables and the column, any idea?

I cannot get the catalog running and read the knowledge base :
ArticleID -317746
http://support.microsoft.com/kb/317746/en-us
So I issued the command said in the article against the master db in QA.

I have a SQL Code to retreive messages from a server that have been posted
in the last 7 days.  See below.
SELECT     TOP 100 PERCENT Name, Subject, [Date], Message, messageID
FROM         dbo.Messages

I can execute the following to identify a word count:
select fulltextcatalogproperty('items_idx', 'UniqueKeyCount') as count;
If I execute this locally I get a count as intended. If I include this
query in interface code, though, it comes back with a null object

Anyone knows where can download/buy a iFilter for pdf ?

I develop an ASP.NET application which is connected to SQL 2005.
I encounter a problem, it is that always the first request that I sending on
fields contained in a full-text index is extremely slow and always exceed
the 30 seconds; the requests which follow are very fast (1 ...

I would like to start population of Full Text Index from my stored
procedure. In SQL Books Online I found this: The FullTextPopulation
method starts or stops Microsoft Search full-text table population,
building the index supporting full-text queries on data maintained by

I need a  simple information.
I read into msdn that incremental population requires a timestamp
column on the table full-text indexed.
Well, I have.

Bit of a teaser how can you achieve this.
Assume a search criteria i.e SQL AND Server
I want to not return the top 5 records but a random 5 records.
You can add anything to the indexed column and you can add anything to the

I posted this message some time ago on
microsoft.public.sqlserver.programming but got no replies.  Today I
found this group so maybe I'll have better luck :)
I have a table with a full-text index on a given column.  If I run the