SQL Server - Still have stuck Pending Changes

Asked By Kyle Jedrusiak on 04-Jun-07 12:17 PM
We have updated our server to the latest updates from MS.

We have a set of indexed views (21 in total).  They are set to Track Changes
Automatically.

The problem is that they're not doing it.  The pending changes are stuck in
limbo.

I have to individually turn the Track Changes Automatically off and back on
before the server starts the processing the data.

I know Ms. Cotter mentioned this as a bug that was fixed in SP1, we
currently have...
Microsoft SQL Server 2005 - 9.00.3054.00 (Intel X86) Mar 23 2007 16:28:52
Copyright (c) 1988-2005 Microsoft Corporation Enterprise Edition on Windows
NT 5.2 (Build 3790: Service Pack 2)

Is this still an issue?




Kyle Jedrusiak replied on 04-Jun-07 01:29 PM
Also, tried turning Track Changes off and back to auto programatically.
This did not for SQL to update the indexes.

Only doing it manually seems to work.
Kyle Jedrusiak replied on 05-Jun-07 08:38 AM
Since Track Changes Automatically doesn't seem to be working, I have a
work-around for now.

I've set Track Changes to Manual.  Then I added a new SQL Job that runs
every X minutes and forces updates programatically.

The line is...

alter fulltext index on ft_indexed_object start update population