THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - 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

Comments

 

Glenn Berry said:

Greg,

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!

Regards,

Greg

June 4, 2009 9:10 PM
 

reserve said:

this would be display an error

January 22, 2013 2:11 AM

Leave a Comment

(required) 
(required) 
Submit

This Blog

Syndication

Tags

No tags have been created or used yet.

Archives

Privacy Statement