How to find out which objects failed to fulltext index
-
Thursday, January 19, 2012 11:54 AM
Hi,
I have some objects (Blobs) which have status TableFulltextFailCount. How can I find out which blobs have these status?
Thank you
All Replies
-
Thursday, January 19, 2012 12:29 PMYou will need to look in the sql fts error logs for your catalog. The PK or full text index key information for the failed populations will be stored there.
looking for a book on SQL Server 2008 Administration? http://www.amazon.com/Microsoft-Server-2008-Management-Administration/dp/067233044X looking for a book on SQL Server 2008 Full-Text Search? http://www.amazon.com/Pro-Full-Text-Search-Server-2008/dp/1430215941 -
Friday, January 20, 2012 7:41 PM
I have quite a lot nonsense in the logs... full text index keys like -0, 0, -7487872384.
There are no such keys.
What's that?
.png)
