Unanswered: UPDATE Active Directory userdate from a SQLServer
I have linked a SQLServer with ActiveDirectory and it rocks, but now after my number one million select statement, i would like to try something new...... Namely to update data on Linked AD, from the SQL server.
Any who know how to do a simple Update with openquery??
Re: UPDATE Active Directory userdate from a SQLServer
Nope cant use ADSI as it dosnt provide access to all the fields in Active Directory, but only to those fields that was available on the NT4.0, so have to use the LDAP query string to get full access to all the user fields as listed on M$'s page here.
So ADSI in a purely Windows 2000 environment is pretty useless as i se it, as it isnt even possible to pull out the email, firstname, lastname & phone/mobile fields from Active Directory, but have to use LDAP to get those.