Office Document Properties

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
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.
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
"Steve W" <BunnyBoy123@.community.nospam> wrote in message
news:enEwUtxBGHA.3792@.TK2MSFTNGP10.phx.gbl...
> 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
>

odd Indexing errors

I have been getting odd errors concerning indexes. When im trying to insert into a table it will post an error
index number_____ belongs to table x not table y
this error causes a failure in processing the code. If I go to the table in enterprise manager and open it and then close it, it seems to reassociate the indexes with the table and then there are no problems. Does anyone know why the indexes are getting confused?
JimDid you DBCC CHECKTABLE?|||Or dbcc dbreindex.|||Originally posted by rnealejr
Or dbcc dbreindex.

Any idea why the indexes are getting corrupted?
Jim|||Can you post your insert statements and some DDL?|||is this the message you're getting?

Attempt to fetch logical page %S_PGID in database '%.*ls' belongs to object '%.*ls', not to object '%.*ls'.|||Originally posted by ms_sql_dba
is this the message you're getting?

Attempt to fetch logical page %S_PGID in database '%.*ls' belongs to object '%.*ls', not to object '%.*ls'.

yes that is exactly the mesg
Jim|||I don't know if you read this post from microsoft:

link (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/trblsql/tr_reslsyserr_1_23lh.asp)

Also, I would run some hardware diagnostics on your hard disks.|||Originally posted by rnealejr
I don't know if you read this post from microsoft:

link (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/trblsql/tr_reslsyserr_1_23lh.asp)

Also, I would run some hardware diagnostics on your hard disks.

I have 1.3 terabites of disk space...what diagnostics would you recomend?
Jim|||Originally posted by rnealejr
I don't know if you read this post from microsoft:

link (http://msdn.microsoft.com/library/default.asp?url=/library/en-us/trblsql/tr_reslsyserr_1_23lh.asp)

Also, I would run some hardware diagnostics on your hard disks.

DBCC CHECKDB ('maersk data warehouse') returned no errors...maybe i have write caching on...thats the only other thing that I can think of.
Jim