SQL Script to update Existing Full text Catalog

• Jarvis Allen

  SSC Journeyman

  Points: 77

  More actions

  March 17, 2015 at 5:38 pm

  #296159

  Have installed SQL Server 2008 R2 Express (includes SSMS tool) on Windows server 2008 R2 sp1 without any issues.

  Database created with no issues, full text catalog created via the wizard also with no issues but cannot run the process as a scheduled task of updating the catalog because the SQL agent is not available in the express version.

  The full text index information is already being populated and updated by a third party application so this leaves just the catalog to be updated as and when new full text information is available.

  I have a third party SQL scheduler which will run SQL scheduled tasks but requires a script to run the full text catalog update process

  Is it possible to extract a script from the existing full text catalog to run the update process or does any of you experts know how a create a script from scratch to do the same update catalog process in the third party scheduler?

  Thanks in anticipation

• Jason-299789

  SSC-Insane

  Points: 21601

  More actions

  March 18, 2015 at 2:15 am

  #1784669

  Not sure if this will help but here is a link to a couple of examples https://msdn.microsoft.com/en-us/library/ms142575(v=sql.105).aspx

  Effectively the sql appears to be

  ALTER FULLTEXT INDEX ON <MyTable> START UPDATE POPULATION;

  _________________________________________________________________________
  SSC Guide to Posting and Best Practices