I was wondering if there is a way to list all the document properties (meta data). There is a way to let Full-Text Search index and search through document properties. I can make a list of properties SQL Server Indexes with the following statement:
SELECT * FROM sys.registered_search_properties;
I can also extend this list with SQL or using a program.
What I didn't find is a way to list the actual information. What I'm looking for is a list like:
- Author: Ruud van de Beeten
- Title: Test document
- custom property: custom value
Can anyone point me in the right direction?
Edit: Bob Beauchemin created a ticket describing my problem. As the DMV is not listing the property values, I can't use it in my project.
I ended up using C# to list custom properties with the OleDocumentProperties object. This object can read properties from an Office document. I'll keep watching this question, hoping for a better solution.