SQL Server accesses exchange data

Someone is looking for SQL Server to store email data on the Internet. In fact, SQL Server provides OLE DB provider to access exchange.

 

Microsoft ole db provider for exchange publicly stores data in Microsoft Exchange 2000 Web store in tabular form. You can use an SQL language similar to the SQL subset supported by OLE DB provider for Microsoft Indexing Service to query the data.

 

Microsoft SQL Server Distributed Query can be used to query data in Exchange Web store through this ole db access interface, and can be connected to tables in SQL Server. Exchange Web store should be on the same computer as SQL Server. You cannot access the Web store on another computer through ole db provider for exchange.

Ole db provider for exchange is included with Microsoft Exchange 2000.

 

Excheng 2007 is also supported.

 

More Info: ole db provider for exchange: http://msdn.microsoft.com/zh-cn/library/ms191461 (V = SQL .100). aspx