Microsoft KB Archive/240681

= HOWTO: Query Index Server for Custom Properties with SQL Query Analyzer =

Article ID: 240681

Article Last Modified on 7/2/2004

-

APPLIES TO


 * Microsoft SQL Server 7.0 Standard Edition
 * Microsoft Windows Indexing Service 2.0

-



This article was previously published under Q240681



SUMMARY
You can use SQL Server 7.0 to query against the Microsoft Indexing Service. This is covered in the SQL Server documentation under the topic "Full-text Querying of File Data." In some cases, it may be desirable to query against custom properties cataloged by Index Server.



MORE INFORMATION
Given the following line in a HTML page cataloged by Index Server,  the following Microsoft Knowledge Base Article explains how to query for and display the "Generator" property:

185985 Using Index Server to Query and Display META TAG Information

Notice that the Generator property must be defined before it can be used. This is true in SQL Server.

The following syntax can be used to query for the Generator property using SQL Server: SELECT Q.FileName, Q.Size, Q.DocAuthor, Q.generator

FROM OpenQuery(FTIndexWeb,   'SET PROPERTYNAME d1b5d3f0-c0b3-11cf-9a92-00a0c908dbf1     PROPID generator     AS generator TYPE DBTYPE_STR;      SELECT FileName, Size, DocAuthor, generator    FROM SCOPE( "E:\Inetpub\wwwroot" )'    ) AS Q WHERE Q.generator LIKE 'Microsoft Developer Studio'

