Export (0) Print
Expand All

Search Property List Editor

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.

For information about how to create, view, or delete a search property list, and about how to configure a full-text index for property searching, see Search Document Properties with Search Property Lists.

Property Name

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.

Note Note

Document properties that use string identifiers are not supported by full-text search.

Property Description

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

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft