CODEWITHSUNDEEP
sql-server-2008full-text-searchrebuildpopulationfull-text-catalog
Jane Hsiun
Jane Hsiun

Reputation: 46

rebuild fulltext catalog will invoke a full population in sql server 2008

I had set Change Tracking to Manual,when I execute 

sp_fulltext_catalog 'myfulltextCatalog','rebuild',

a rebuilding is started.But I have found that the PopulateStatus of the fulltext catalog is changed to value 1,that means a full population is in progress. As the microsoft's Books Online says,rebuild command will not populate the catalog.So I am very confused.Anyone knows?

Upvotes: 0

Views: 648

Answers (1)

Jane Hsiun
Jane Hsiun

Reputation: 46

oh,my god. I know the reason.

if Changeing Tracking!=off,rebuild will start a population.

But SQL Server Books Online says that rebuilding does not change any full-text metadata in the database system tables ,nor does it cause the repopulation of the newly created full-text catalog.

Upvotes: 0

Related Questions