Exchange mailboxes access via SQL Server? | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Exchange mailboxes access via SQL Server?

Hello all–<br /><br />we would like to have access to an exchange mailbox via SQL. From what I understand, SQL 2000/2005 have "hooks" into Exchange. Not sure if an exchange mailbox becomes an object linked server etc… Anyone have any info on how this is done? (I’m checking here before I contact Microsoft) <img src=’/community/emoticons/emotion-5.gif’ alt=’;-)’ /><br /><br />as always thanks for your help<br /><br /><br /><br />it’s all good
You need to configure SQLmail or SQLagent mail to get connect to MSEXCHANGE.
please refer;en-us;263556
after config you can send mail as reffered in link. for receivin mails just refer to xp_sendmail in BOL -Rajiv
thanks Rajiv we have SQL mail set up and use xp_sendmail extensively. Is there a way to treat exchange mailboxes as a relational table? We can programmatically read the email (via .NET) and dump the emails into a table but I’m sure microsoft has set up Exchange mailboxes to be available to SQL Sever. We are running SQL 2000
Exchange 2003 it’s all good
Links for your information:…01-2CC9-4A84-A669-EB22533FA5E2&displaylang=en HTH Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
thanks for the info. I’ll keep you posted. it’s all good