Full text catalog does not get associated with the specified FileG

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Sameeksha - 04 Jul 2008 06:05 GMT

Hi

I am trying to create a full text catalog on sql server 2008 feb CTP. The
create command executes successfully, however, the catalog does not get
associated with the filegroup specified in the create command. Trying to open
properties of the catalog results in error that filegroup property is not
available for the catalog.

The query "select fulltext_catalog_id, name, data_space_id from
sys.fulltext_catalogs;" returns data_space_id as null.

Creating a full text index on a table in this database also succeeds,
however, the index does not get populated, and no error is returned.

Command "select FULLTEXTCATALOGPROPERTY('FamulusCatalog', 'IndexSize');"
returns 0 as the index size, and property 'PopulationStatus' shows '0' -
meaning idle.

The query "select fulltext_catalog_id, change_tracking_state_desc,
data_space_id, is_enabled
, crawl_start_date, crawl_end_date, crawl_type_desc from
sys.fulltext_indexes;"
returns crawl_start_date and crawl_end_date differing only by a second or so.

Is there anything which I am missing?

Signature

Thanks,
Sameeksha
MCAD.Net

Reply to this Message

Hilary Cotter - 07 Jul 2008 14:45 GMT

I can't comment on CTP 6 as it is completely obsolete right now.

However in RC0 there is no option in the dialogs as to where you should park
the catalogs, ie which file group.

There is a note in CTP 0's documentation saying:

Note:
The following columns will be removed in a future release of SQL Server:
data_space_id, file_id, and path. Do not use these columns in new
development work, and modify applications that currently use any of these
columns as soon as possible.

> Hi
>
[quoted text clipped - 23 lines]
>
> Is there anything which I am missing?

Reply to this Message

Hilary Cotter - 07 Jul 2008 19:12 GMT

BTW - catalogs are obsolete. They only are a container for properties of
full-text indexes.

> Hi
>
[quoted text clipped - 23 lines]
>
> Is there anything which I am missing?

Reply to this Message