I have the following script which enables full text search on the database:
------------------------------------------------------------------------------
sp_fulltext_database 'enable'
sp_fulltext_catalog 'cntdocimg', 'create'

Machine A (2003 Server, sp1) is running SQL Express with FTI.  Querying
the fulltext catalog returns results as expected and the catalog is kept
up-to-date when data is added/modified in the indexed tables.
Machines B and C (Xp Pro, sp2) are running a restored copy of A's

I am running SQL 2005 SP1 and I have a database I'm using for GFI Mail
Archiver.  When I run queries against the database for a specific word i.e
"testing", only 2 results show up when there should be more results.  
I know the data is there because I can see it, it's just that ...

I have created a FT Index on a varchar(200) col of my 'movies' table.
The table has about 2000 rows, so there is lots to index.
But even after forcing a catalog rebuild and full population, the catalog
remains empty.

Hey there :)
Sorry if I'm asking dumb questions, but I'm not really a MSSQL man myself,
I've always used MySQL, but this particular project that I'm involved with
right now uses an MSSQL Server. So, I have one question.

I have a problem. I use Constainstable to make a fulltextsearch over 4
tables.
Now I want to order the result set. The problem is that if I insert the
column all_ranks in the Select part I have some double results. That is

We are live (production system) running
- Windows 2003 Data Centre Edition R2 x64
- SQL Server 2005 Enterprise Edition x64 SP 1
The system has been operating fine for 7 days and all of a sudden we have

Is there any function that we can to check the length of the full text
index population and the status(whether it is finished successfully or
failed)?
Now I have to check it from application event log to determine how long

as I read in the SQL 2000 Server FAQ that free text search ranks aren't
suitable for calculating percentage values, what other ways are there
to get sensible results for presenting to a user?
Or are there none at all?

Does anyone know what the services are involved during the SQL full
text index catalog population?
Some of my application event log errors are "Error: 80070426 - The
service has not been started.".

I have a full text index scheduled at every night in SQL server 2000.
Normally the status on the full-text catalog will either "Idle" or
"Incremental population in progress". But today I got "shut down". This
happened to one of our other server yesterday too. Since this happens

We recently upgraded our sql server to 2005 and now all the Full-Text
indexes return zero results.
I have created a new fulltext catalog and a done a full population.
After the population the catalog props read Unique Key Count : 1,

Can anyone advise the latest version(s) of the ifilter we should be using for
a x64 Windows 2003 Server, I'm troublshooting an issue and want to ensure I
have the latest x32 & x64 version's of this file on the relevant server's
etc..

I am getting the following error, when i am trying to pass the NULL value to
the parameter of Stored procedure.  That parameter has been used in Contains
clause in T-SQL.
Server: Msg 7603, Level 15, State 1, Procedure spCMXLSearchReports, Line 256

I have some questions about Full Text Search and how to handle a
scenario that I have. The database that I am going to hit up against
has 80 tables and over 250 fields that will be searched for FTS. This
database has 600 + tables in it so 80 is needed to make the search