Full text catalog does not get associated with the specified FileG   

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

date: Thu, 3 Jul 2008 22:05:00 -0700   author:   Sameeksha

Re: Full text catalog does not get associated with the specified FileG   

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 
news:1D5398BF-6BB3-4E9C-AE59-1C7A42DA54E3@microsoft.com...
> 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

date: Mon, 7 Jul 2008 09:45:19 -0400   author:   Hilary Cotter

Re: Full text catalog does not get associated with the specified FileG   

BTW - catalogs are obsolete. They only are a container for properties of 
full-text indexes.
"Sameeksha"  wrote in message 
news:1D5398BF-6BB3-4E9C-AE59-1C7A42DA54E3@microsoft.com...
> 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

date: Mon, 7 Jul 2008 14:12:48 -0400   author:   Hilary Cotter