Still have stuck Pending Changes

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Kyle Jedrusiak - 04 Jun 2007 17:17 GMT

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?

Reply to this Message

Kyle Jedrusiak - 04 Jun 2007 18:29 GMT

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.

> We have updated our server to the latest updates from MS.
>
[quoted text clipped - 14 lines]
>
> Is this still an issue?

Reply to this Message

Kyle Jedrusiak - 05 Jun 2007 13:38 GMT

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

> We have updated our server to the latest updates from MS.
>
[quoted text clipped - 14 lines]
>
> Is this still an issue?

Reply to this Message