Office Document Properties

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Steve W - 22 Dec 2005 17:14 GMT

If I use the Indexing Services built into the OS, I can query the office
doc properties (title, author etc).

Is it possible to do this if I have an office doc stored in an Image field
that is full-text indexed ?

Steve

Reply to this Message

Hilary Cotter - 22 Dec 2005 23:05 GMT

It is possible in SQL 2005 - however you can't query for a specific
properties' value. IE I could not query to see if the DocAuthor property was
SteveW, but rather I could query to see if SteveW occurred in the content or
any of the document properties.

AS you are familiar with indexing Services the analog is the ALL property.

Signature

Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com

> If I use the Indexing Services built into the OS, I can query the office
> doc properties (title, author etc).
[quoted text clipped - 3 lines]
>
> Steve

Reply to this Message