Freetext catalog

[alexjamesbrown]

I execute the following:


EXEC sp_fulltext_catalog 'DescriptionsOfProducts', 'create'

EXEC sp_fulltext_table 'tblProducts', 'create', 'DescriptionsOfProducts', 'PK__tblProducts__50FB042B'

EXEC sp_fulltext_column 'tblProducts','ProductName','add'
EXEC sp_fulltext_column 'tblProducts','ProductDescription','add'

EXEC sp_fulltext_table 'tblProducts','activate'

EXEC sp_fulltext_catalog 'DescriptionsOfProducts', 'start_full'


On my local pc it works fine... populates the fulltext catalog just great.
however on my web server, it creates everything correctly, however has an item count of 0???

i cannot find whats going on! the databases are identical, both in structure, indexes and data.

any ideas?

 

[AlexCuse]

Maybe it is a version/service pack issue?

Have a look at this:

http://support.microsoft.com/kb/321185/

It will show you how to determine your versions and service pack levels.

It could also be that your web host does not enable the feature you need, I have run into that a few times.

Hope it helps,

Alex

Ignorance of certain subjects is a great part of wisdom