Microsoft KB Archive/259849

= XWEB: How to Perform Full-Text Searching Using WebDAV =

Article ID: 259849

Article Last Modified on 2/21/2007

-

APPLIES TO


 * Microsoft Exchange 2000 Server Standard Edition

-



This article was previously published under Q259849



SUMMARY
To improve search performance on Microsoft Exchange 2000 Server, you can apply full-text searching to a mailbox store or public folder store. This article explains how to create full-text indexing on a public folder store and to use Web Distributed Authoring Version (WebDAV) to perform the full-text searching using CONTAINS or FREETEXT in a WHERE clause of a Structured Query Language (SQL) query.



Steps to Create Full-Text Index

 * 1) In Exchange System Manager, locate the Public Folder Store.
 * 2) Right-click Public Folder Store, point to Create Full-Text Index, accept the default catalog location, and then click OK.
 * 3) Right-click the Public Folder Store again, click Start Full Population, and then click Yes to continue.
 * 4) Look at the Full-Text Indexing subcontainer of the public store, watch the status of the index build, and wait until the index build is finished.
 * 5) Right click Public Folder Store, click Properties, click the Full Test Indexing tab, and then click to check the This index is currently available for searching by clients check box.

Stores with full-text searching applied have the following properties indexed:

Steps to Test the Sample Code
 Create a public folder named &quot;MyPub&quot; under the Public Folders container; this is the folder that you want to search. Post some messages that may or may not contain the word &quot;preliminary&quot; into MyPub.  Create another public folder named &quot;AspApps&quot; under the Public Folders container. Paste the following code to Notepad, modify the code to reflect your server name, and then save it to the AspApps folder as FullTextIndexing.asp. <%@ LANGUAGE=VBScript %>    Simple SEARCH   <%

Response.Write(&quot;begin&quot; + &quot; &quot;) set doc = createobject(&quot;microsoft.xmldom&quot;) set docback = createobject(&quot;microsoft.xmldom&quot;) dim strURL strURL = &quot;http://servername/public/MyPub/&quot; set pi = doc.createProcessingInstruction(&quot;xml&quot;,&quot;version=&quot;&quot;1.0&quot;&quot;&quot;) doc.appendChild pi

set node = doc.createNode(1,&quot;searchrequest&quot;,&quot;DAV:&quot;) set doc.documentElement = node

set node2 = doc.createNode(1,&quot;sql&quot;,&quot;DAV:&quot;) node.appendChild node2 set query = doc.createTextNode(&quot;select &quot;&quot;DAV:displayname&quot;&quot; from &quot;&quot;&quot; & strURL & &quot;&quot;&quot; WHERE CONTAINS('&quot;&quot;preliminary&quot;&quot;')&quot;) node2.appendChild query

set req = createobject(&quot;microsoft.xmlhttp&quot;) req.open &quot;SEARCH&quot;, strURL, false, &quot;MangoDomain\User1&quot;, &quot;user1&quot; req.setrequestheader &quot;Translate&quot;, &quot;f&quot; req.setrequestheader &quot;Content-Type&quot;, &quot;text/xml&quot; req.setrequestheader &quot;Depth&quot;, &quot;0&quot; req.send doc

set docback = req.responseXML

Dim objNodeList

'Typically the DAV namespace get the 'a' prefix. 'If you are specifying multiple properties in a search, 'examine the returned XML beforehand to determine prefixes 'for your code.

Set objNodeList = docback.getElementsByTagName(&quot;a:displayname&quot;) For i = 0 To (objNodeList.length -1) Set objNode = objNodeList.nextNode Response.Write(objNode.Text & &quot; &quot;) Next

Response.Write(&quot;end&quot; + &quot; &quot;)

%> </BODY> </HTML>

</li> Run the .asp from Internet Explorer using the following URL format:

http:// /public/aspapps/FullTextIndexing.asp

</li> A list of all the display names of the messages that meet the search criteria is returned.</li></ol>

Additional query words: Full-Text Indexing Search full text fts

Keywords: kbhowto KB259849

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.