This documentation is archived and is not being maintained.


Exchange Server 2003


This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.

The Exchange store is a vast store of resources in a single infrastructure, and search capabilities are provided for locating specific items or to create views of resource data. You can search for items in the Exchange store using a familiar Structured Query Language (SQL) syntax, which is based on the syntax defined by the Microsoft Indexing Service Query Processor.

When searching the Exchange store using Microsoft® ActiveX® Data Objects (ADO) or OLE DB, search results are returned in Recordset or Rowset objects. When searching using WebDAV, results are returned as XML elements in the body of an HTTP response.

Indexing properties and implementing full-text indexing improves search performance. For more information about these capabilities, see Indexing.

If you are using WebDAV, you can create Search Folders to persist search results in a folder addressable by URLs and also searchable by other queries.

The Microsoft Indexing Service search engine operates by using a system account, enabling it to read all stores, including private mailboxes. To maintain security, Rowset objects returned from an SQL query are evaluated against the access control list (ACL) of the item or folder searched and the security identifier of the user. Any row in which grant access is restricted is removed before the search result is returned.

This section consists of the following topics:

The SELECT Statement

The SELECT * Statement

Search Scope

Search Folders

Related Topics