Hi,

I need to bcp records into tables with full text indexes. As I understand, it is a good idea to remove indexes prior to inserting records for performance reasons. All articles I've read about it mention dropping indexes and recreating them after a table is updated, but sp_fulltext_database allows to disable indexes without dropping them. Here is the description of the 'disable' option from MS site:

Removes all full-text catalogs in the file system for the current database and marks the database as being disabled for full-text indexing. This action does not change any full-text index metadata at the full-text catalog or table level.

Does anyone know what is the best way to remove indexes before bcp-ing data in?

Thanks in advance,

Yana