Full text catalog does not get associated with the specifi..

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?
--
Thanks,
Sameeksha
MCAD.Net

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.




"Sameeksha" wrote in message

> 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?
> --
> Thanks,
> Sameeksha
> MCAD.Net