Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).
Use this dialog box to add or delete search properties in a search property list.
Specify the name to be used to identify the property in full-text queries. A property name can contain internal spaces. The maximum length of Property Name is 256 characters. This name can be a user-friendly name, such as "Author" or "Home Address", or it can be the Windows canonical name of the property, such as System.Author or System.Contact.HomeAddress. Property Name must uniquely identify the property within the property set.
Developers use the property name to identify the property in the CONTAINS predicate. Therefore, when adding a property it is important to specify a value that meaningfully represents the property.
Property Set GUID
Specify the identifier of the property set to which the property belongs. This is a globally unique identifier (GUID). A property set is a group of logically related properties. For information about obtaining this value, see "Remarks," later in this topic.
Property Int ID
Specify the property integer identifier of the property. This pre-assigned value is a positive integer that is unique within the property set. For information about obtaining this value, see "Remarks," later in this topic.
Document properties that use string identifiers are not supported by full-text search.
Optionally, specify a description of the property. This is a string of up to 512 characters. For example, a description could contain information about the property set of the property or information about a property that is not evident from its name.
To add a search property to a search property list, you must specify the globally unique identifier (GUID) of the property set to which the property belongs and the property integer identifier of the property. A given combination of these must be unique in a given search property list. If you try to add an existing combination, the operation fails and issues an error. This means that you can configure only one name for a given property.
The property description is optional.
To configure a search property list for a full-text index