SQL Server Performance Forum – Threads Archive

Exchange mailboxes access via SQL Server?

Hello all– 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=’;-)’ /> as always thanks for your help it’s all good

You need to configure SQLmail or SQLagent mail to get connect to MSEXCHANGE.
please refer
http://support.microsoft.com/default.aspx?scid=kb;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:
http://www.outlookcode.com/d/database.htm
http://www.microsoft.com/downloads/…01-2CC9-4A84-A669-EB22533FA5E2&displaylang=en
http://www.officerecovery.com/exchangeserver/ HTH Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
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

]]>