Document properties

Can somebody point me to where I can learn how to query the properties
of files stored in an image field. I'm having troubles finding that
documentation. I'm using SQL 2005.
Larry Brown wrote:
> Hi,
> In Office documents for example, you have document properties like
> Doc_Author, or other properties that may have been created by the user who
> wrote the doc.
> In SQL Server 2005, it is possible to search into these properties
> (equivalent of Index Server ALL property). But is there any way to get the
> list of properties with their values ? Meaning to know that the value has
> been found in one property rather than in another ?
> Is there any difference if I use Sharepoint, Services or Portal ?
> My problem is that I'm using not only Office iFilter with document
> properties, but two other iFilters that I created for indexing PDF and
> another format specific to my company, with Index Server. Both these
> iFilters manage document properties, including possibility to create custom
> properties...
> Looks like I will have to do some programming...
> Many thanks in advance
Hello,
Its not possible.
Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons
[vbcol=seagreen]
> Can somebody point me to where I can learn how to query the properties
> of files stored in an image field. I'm having troubles finding that
> documentation. I'm using SQL 2005.
> Larry Brown wrote:
|||So Larry was mistaken?
"In SQL Server 2005, it is possible to search into these properties
(equivalent of Index Server ALL property)."
|||You can query them if they are emitted by the iFilter. The best way to
determine if they are emitted is to run them through filtdump accessible
from the platform sdk.
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
<ddaiker@.gmail.com> wrote in message
news:1166470714.092854.303040@.79g2000cws.googlegro ups.com...
> Can somebody point me to where I can learn how to query the properties
> of files stored in an image field. I'm having troubles finding that
> documentation. I'm using SQL 2005.
> Larry Brown wrote:
>
|||It is possible to search on properties which are embedded in the document
and accessible through the iFilter-for example the summary properties in
office documents. For some documents, i.e. some pdf properties they are
actually stored in the file system and when you push them into the database
they remain in the file system and don't travel with the document itself.
The best way to see this is to put a value for the keyword metatag of an
html,. store it in an image datatype column and then search on the keyword
value. You will get a hit.
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
"ddaiker" <ddaiker@.gmail.com> wrote in message
news:1166473176.174934.179730@.f1g2000cwa.googlegro ups.com...
> So Larry was mistaken?
> "In SQL Server 2005, it is possible to search into these properties
> (equivalent of Index Server ALL property)."
>
|||Hello Hilary,
But you can't do search for a specific value in a specific property, like
you can with index server
Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons
[vbcol=seagreen]
> You can query them if they are emitted by the iFilter. The best way to
> determine if they are emitted is to run them through filtdump
> accessible from the platform sdk.
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> <ddaiker@.gmail.com> wrote in message
> news:1166470714.092854.303040@.79g2000cws.googlegro ups.com...