Post reply

Full-Text Index - script for checking for auto-populate status

  • July 28, 2011 at 6:44 am

    #150388

    Greetings all;

    I have a rather odd situation where my full-text indexes, which were originally set to auto-populate are for some reason getting set to Manual. This causes issues with my Full-Text index being out of date, of course.

    I have limited amount of time to dig into this issue and would rather have a script that runs against all of my database FT indexes to see which one's have been set to manual. Anyone help out here?

    This issue has surfaced some time ago and not sure of what the real cause of it is.

    Thanks in advance.

    Kurt Zimmerman

    Kurt W. Zimmerman
    SR DBA
    Lefrak Organization
    New York, NY

    http://www.linkedin.com/in/kurtwzimmerman

  • July 28, 2011 at 11:00 am

    #1360339

    Well folks... I managed to spend some time on this and I got the answer.... along with a job that runs to check the status

    I found this:

    select objectproperty(object_id('table name'),'TableFullTextBackgroundUpdateIndexOn')

    This is the premise that I use to run through all of my databases and check the known tables that have been set up in the FT index. The good news is that in my production environment I found all my issues. However in my UAT environment was a different story.

    Thanks for looking folks.

    Kurt

    Kurt W. Zimmerman
    SR DBA
    Lefrak Organization
    New York, NY

    http://www.linkedin.com/in/kurtwzimmerman

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply