Link to Exchange

jfleming · December 29th, 2004, 04:17 PM

I have a SQL 2000 server I want to link to an Exchange Server. Can I used linked servers to access the Exchange database? I do not want to have to import my email addresses into a SQL table for updates.

Thank you,
JLFleming

jemacc · December 29th, 2004, 05:14 PM

--The following line creates the linked server:

Code:

sp_addlinkedserver 'ADSI', 'Active Directory Service Interfaces',

Code:

'ADSDSOObject', 'adsdatasource'

see the MSDN Help for 'ADSDSOObject' provider details.

Jaime E. Maccou

jfleming · January 3rd, 2005, 08:45 AM

Will this give me access to the Exchange database?

Thank you,
JLFleming

jemacc · January 3rd, 2005, 09:40 AM

What this will do is make a connection to Exchange to query.

Exchange does not yet store information in a structural database like SQL

Jaime E. Maccou