THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Greg Low (The Bit Bucket: IDisposable)

Ramblings of Greg Low (SQL Server MVP, MCM and Microsoft RD) - SQL Down Under

SQL Server 2008 Full Text Indexing - Working out how many documents still need to be processed

Published Wednesday, June 3, 2009 8:35 PM by Greg Low

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS



Glenn Berry said:


This query seems to work pretty well for getting the number of pending changes:

-- Find out how many changes are pending

SELECT OBJECTPROPERTY(OBJECT_ID('CurrentPostFullTextMonday'), 'TableFulltextPendingChanges') AS 'Full Text Pending Changes';

You will have to change CurrentPostFullTextMonday to your FT index name.

June 4, 2009 2:04 PM

Greg Low said:

Hi Glenn,

Thanks, yep, that'll work for the situation where we only want to know the number, rather than details on which documents are still outstanding. Often that's all that's needed so that's excellent thanks!



June 4, 2009 9:10 PM

reserve said:

this would be display an error

January 22, 2013 2:11 AM

Leave a Comment


This Blog



No tags have been created or used yet.


Privacy Statement