What to do after editing a noise words file

• maryP

  Old Hand

  Points: 302

  More actions

  June 14, 2007 at 9:25 am

  #179215

  I have to remove the single letter noise words from the noise.enu file for a sql server 2000 instance.  There are mulitple database on the server, only 1 needing the full-text searching.  It already has a full-text catalog associated with the database. 

  I'm just trying to figure out if after I edit the noise.enu file, do I have to rebuild the catalog or can I just select the full populate opition in the database?

  (I know I need to stop the full-text search service to edit the file.)

  Thanks for any help - I inherited this and don't have a clue as to whaat I'm doing.  I gave up perusing through BOL.

  -Mary

• Antares686

  SSC Guru

  Points: 125444

  More actions

  June 14, 2007 at 10:12 am

  #713002

  Direct from MS

  If you edit a noise-word file, you must repopulate the full-text catalogs before the changes will take effect.)

  http://msdn2.microsoft.com/en-us/library/aa172881(sql.80).aspx