Still have stuck Pending Changes

Still have stuck Pending Changes

Post by Kyle Jedru » Wed, 06 Jun 2007 01:17:28


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?
 
 
 

Still have stuck Pending Changes

Post by Kyle Jedru » Wed, 06 Jun 2007 02:29:39

Also, tried turning Track Changes off and back to auto programatically.
This didn't for SQL to update the indexes.

Only doing it manually seems to work.

 
 
 

Still have stuck Pending Changes

Post by Kyle Jedru » Wed, 06 Jun 2007 21:38:51

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