Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Other Technologies / Full-Text Search / February 2008

Tip: Looking for answers? Try searching our database.

Can't repopulate Catalog: change tracking not working/repopulate     catalog grayed out

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
dreamer@gmail.com - 14 Feb 2008 19:54 GMT
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 -
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.