Thursday, January 19, 2012 11:54 AM
I have some objects (Blobs) which have status TableFulltextFailCount. How can I find out which blobs have these status?
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.