Hello,
I am using SQL server 2005. I have added some tables to a catalog
(they have auto increment PK, timestamps and change tracking is
enabled). The database was backed up/restored from SQL server 2000 to
SQL server 2005.
Here's the issue:
- When I insert new records, they're not added to the catalog (I can't
search for them but I can find older records). So change tracking does
not seem to work.
- I tried rebuilding the catalog with no luck
- "Repopulate Catalog" under Full Text catalog properties is grayed
out/disabled
- I tried running EXEC sp_fulltext_catalog 'myCatalog', 'start_full'
and exec sp_fulltext_catalog 'myCatalog', 'start_incremental' but I
get the following error for each table in the catalog:
Warning: Request to start a full-text index population on table or
indexed view 'dbo.TestTable' is ignored because a population is
currently active for this table or indexed view.
Any idea why change tracking is not working and repopulate catalog is
grayed out?
I really appreciate your help
Ben
dreamer@gmail.com - 17 Feb 2008 04:25 GMT
On Feb 14, 11:54 am, drea...@gmail.com wrote:
> Hello,
>
[quoted text clipped - 22 lines]
>
> Ben
Anybody has any idea?
Thanks!
Ben
Hilary Cotter - 18 Feb 2008 20:36 GMT
You may have to wait until the population is complete.
Did you try this
alter fulltext index on tableName set change_tracking auto
On Feb 16, 11:25 pm, drea...@gmail.com wrote:
> On Feb 14, 11:54 am, drea...@gmail.com wrote:
>
[quoted text clipped - 32 lines]
>
> - Show quoted text -