How to find out which objects failed to fulltext index

Question

Hi,

 

I have some objects (Blobs) which have status TableFulltextFailCount. How can I find out which blobs have these status?

 

Thank you

Answer 1

You 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

Answer 2

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?