<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="http://mswindowscr.org/utility/FeedStylesheets/rss.xsl" media="screen"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:wfw="http://wellformedweb.org/CommentAPI/"><channel><title>Query Active Directory from SQL Server</title><link>http://mswindowscr.org/blogs/sql/archive/2010/03/10/query-active-directory-from-sql-server.aspx</link><description>If you need to access some Active Directory information from SQL Server you can use the openquery command with the ADSI provider, below is an example for doing that select * from openquery(adsi, &amp;#39; select displayName from &amp;#39;&amp;#39;LDAP://dc=comunidadwindows</description><dc:language>en</dc:language><generator>CommunityServer 2007.1 (Build: 20917.1142)</generator></channel></rss>