Post reply

Recommended frequency for running a fulltext catalog incremental?

  • December 28, 2006 at 8:32 am

    #115846

    I'm new to full text catalogs and we have a vendor who's code utilizes them.  The database server is SQL 2005 and I am noticing the following message in the SQL log every minute.

    Changing the status to MERGE for full-text catalog "ResearchCatalog" (5) in database "DBA_Test" (11). This is an informational message only. No user action is required.

    A SQL job is running the following command every minute.

    exec sp_fulltext_catalog 'ResearchCatalog', 'start_incremental'

    What is the typical frequency for running an incremental? 

    Can the messages be suppressed?

    Thanks,  Dave

  • December 28, 2006 at 10:31 am

    #680313

    The sp_fulltext_catalog stored procedure will be removed in a future version of SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use the stored procedure. Use the new full-text data definition language (DDL) statements instead. For more information, see the CREATE, ALTER, DROP FULLTEXT CATALOG topics.

    See the thread...

    http://groups.google.com/group/microsoft.public.sqlserver.fulltext/browse_thread/thread/d308d458b6ae2669/ef9058529e7b5adb?lnk=st&q=fulltext+catalog+incremental+frequency&rnum=3#ef9058529e7b5adb

     

    MohammedU
    Microsoft SQL Server MVP

  • December 28, 2006 at 10:44 am

    #680318

    I'm aware of this, however the vendor insists on using the command with the argument being it will be a few years before the next version of SQL Server is released.

    Dave

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

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