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, wrote:
> On Feb 14, 11:54 am, wrote:
>
>
>
>
>
> > 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'tsearchfor 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" underFullTextcatalog 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 afull-textindex 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
>
> Anybody has any idea?
>
> Thanks!
>
> Ben- Hide quoted text -
>
> - Show quoted text - >> Stay informed about: Can't repopulate Catalog: change tracking not working/repo.. 
FAQ
Search
Profile
Private Messages
Log in
