Controls how full-text indexes are migrated when upgrading a database from SQL Server 2000 or SQL Server 2005 to SQL Server 2008 or later version. This property applies to upgrading by attaching a database, restoring a database backup, restoring a file backup, or copying the database by using the Copy Database Wizard.
0 = Full-text catalogs are rebuilt using the new and enhanced word breakers. Rebuilding indexes can take awhile, and a significant amount of CPU and memory might be required after the upgrade.
1 = Full-text catalogs are reset. SQL Server 2005 full-text catalog files are removed, but the metadata for full-text catalogs and full-text indexes is retained. After being upgraded, all full-text indexes are disabled for change tracking and crawls are not started automatically. The catalog will remain empty until you manually issue a full population, after the upgrade completes.
2 = Full-text catalogs are imported. Typically, import is significantly faster than rebuild. For example, when using only one CPU, import runs about 10 times faster than rebuild. However, an imported full-text catalog does not use the new and enhanced word breakers introduced in SQL Server 2008, so you might want to rebuild your full-text catalogs eventually.
Rebuild can run in multi-threaded mode, and if more than 10 CPUs are available, rebuild might run faster than import if you allow rebuild to use all of the CPUs.
If a full-text catalog is not available, the associated full-text indexes are rebuilt. This option is available for only SQL Server 2005 databases.
For information about choosing a full-text upgrade option, see full-Full-Text Search Upgrade.
Indicates whether operating system word breakers, stemmers, and filters are registered and used with this instance of SQL Server. One of:
0 = Use only filters and word breakers specific to this instance of SQL Server.
1 = Load operating system filters and word breakers.
By default, this property is disabled to prevent inadvertent behavior changes by updates made to the operating system. Enabling use of operating system resources provides access to resources for languages and document types registered with Microsoft Indexing Service that do not have an instance-specific resource installed. If you enable the loading of operating system resources, ensure that the operating system resources are trusted signed binaries; otherwise, they cannot be loaded when verify_signature (see below) is set to 1.
Specifies whether full-text indexing should be paused, if it is currently running, or resumed, if it is currently paused.
0 = Resumes full-text indexing activities for the server instance.
1 = Pauses full-text indexing activities for the server instance.
Updates the list of languages and filters that are registered with full-text search. The languages are specified when configuring indexing and in full-text queries. Filters are used by the filter daemon host to extract textual information from corresponding file formats such as .docx stored in data types, such as varbinary, varbinary(max), image, or xml, for full-text indexing.
For more information, see How to: Alter the List of Registered Word Breakers and Filters (Transact-SQL).
Indicates whether only signed binaries are loaded by the Full-Text Engine. By default, only trusted, signed binaries are loaded.
1 = Verify that only trusted, signed binaries are loaded (default).
0 = Do not verify whether binaries are signed.