How to get the full-text search working for Office document (docx) in SQL Server

Run the following query in SQL Server Management Studio.

SELECT document_type, class_id,[path] FROM sys.fulltext_document_types

WHERE document_type = N'.docx';

SELECT *

FROM TableName

WHERE FREETEXT(*, 'ram') and filetype='docx'

If the free text is not giving the result for documents(docx), then download the Microsoft Filer pack from the following links.

Microsoft Office 2007 Filter Packs

http://www.microsoft.com/downloads/details.aspx?FamilyId=60C92A37-719C-4077-B5C6-CAC34F4227CC&displaylang=en

Microsoft Office 2010 Filter Packs

http://go.microsoft.com/fwlink/?LinkId=179530

1. Download and install Microsoft Filter Pack,

2. Enable IFilters, and then run the following command in that instance:

sp_fulltext_service 'load_os_resources', 1

3. Restart the SQL Server service.

4. Refresh the document Catalog of the database.

5. Disable and Re-enable the Full Text Index of the table.

For more information, please see：

How to register Microsoft Filter Pack IFilters with SQL Server 2005 and with SQL Server 2008

If you had registered, I think we need to verify whether the file name extension correct.

Outlook 2010 App crash

The Outlook view control (OVC) which is used in the windows application works fine with Outlook 2007 but crashes when used in Outlook 2010. This is mainly due to the shutdown change behavior of Outlook 2010. When a user exits Outlook 2010, Outlook now shutdowns completely. This affects the outlook view control and results in app crash.

However, if the outlook 2010 is running separately in Background, then everything works fine.

Sources:

http://social.msdn.microsoft.com/Forums/en-US/outlookdev/thread/d206a642-95e3-42d2-98e0-98bf15dbc38f/

http://support.microsoft.com/kb/2511230

http://social.msdn.microsoft.com/Forums/en-US/outlookdev/thread/8e60581f-7a10-47c5-9dd5-7205c7628537/

http://social.msdn.microsoft.com/Forums/da-DK/outlookdev/thread/f2f5cb0f-5ce6-4d57-930c-43bd2a07f6a1