Ifilter and Office Extended Properties

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » SQL Server 2005 General Discussion » Ifilter and Office Extended Properties

Ifilter and Office Extended Properties

Rate Topic

Display Mode

Topic Options

Author

Message

Stephanie Martin

Posted Wednesday, August 04, 2010 3:39 PM

Forum Newbie

Group: General Forum Members
Last Login: Monday, February 11, 2013 9:57 AM
Points: 1, Visits: 18

I use the standard ifilters with SQL Server to full-text index various Office documents with great success. Sometimes the documents are held in the database in IMAGE columns, other times I use linked servers to index documents held on the file system. However, I noticed that I can't search the text in Office document properties such as "Comments" or custom attributes. Specifically Word.

I have been trying to find official documentation from Microsoft indicating what the Office ifilters are supposed to index so I can say for certain if the extended properties of a Word document should be searchable or not. I can't seem to find anything other than generic documentation that say that Office documents can be searched.

My typical environment is Windows 2003/SQL 2005...however, the question is still applicable for Windows 2003+ and SQL 2005+. Does any one have a page that describes this specific feature for ifilters? Thanks so much in advance.

Post #963864

« Prev Topic | Next Topic »

Permissions