Connecting SQL databsae to global address list

[boatdrinks]

I am running sql 2000 and exchange 2000. How can I create a sql table from the exchange global address list? I want to continue to update it then afterwords..

 

[mrdenny]

They was I was able to do this on Exchange 5.5 (and there may be a cooler way to do it on Ex 2k) was to use one of the exchange command line tools to export the GAL to a CSV, the import the data into the SQL Server via bulk insert, and process it accordingly.

Since Exchange 2k is based on AD you should be able to setup a linked server to the directory service in AD. Here is a Microsoft article on getting it setup.

http://support.microsoft.com/default.aspx?scid=kb;en-us;Q299410

Denny

--Anything is possible. All it takes is a little research. (Me)