Post reply

SQL 2005 equivalent for sysfulltextnotify

  • April 20, 2009 at 1:16 pm

    #130198

    SQL 2000 had sysfulltextnotify providing view of full text index tracked changes.

    Is there a SQL 2005 equivalent for sysfulltextnotify ?

    Or, a different way to examine the full text index "tracked changes" information?

  • April 20, 2009 at 1:32 pm

    #981005

    Full Text is very different in 2005 it is built in part of the relational engine you can auto populate so if you are upgrading drop all 2000 full text indexes and create new ones with auto populate option. Please read up on changes of full text before upgrade.

    Kind regards,
    Gift Peddie

  • April 20, 2009 at 1:40 pm

    #981012

    Thanks. I am creating everything new in 2005.

    I ask about sysfulltextnotify as I saw it in an optimization article for 2000 as a view that would show you the row info for tracked changes of a full text index and was hoping a similar mechanism was available in 2005 so that I can monitor/investigate change tracking.

  • April 20, 2009 at 1:51 pm

    #981025

    Per the breaking changes docs it does not exist however you could still run it check below for details.

    http://msdn.microsoft.com/en-us/library/ms143709(SQL.90).aspx

    Kind regards,
    Gift Peddie

  • April 20, 2009 at 7:05 pm

    #981145

    Check DMV named sys.dm_fts_active_catalogs.

    MJ

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

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