shepherdweb.com

Archive for July 20th, 2006

How to Query Active Directory Using Enterprise Manager

Thursday, July 20th, 2006

Step 1 Open Security and find Linked Servers (Figure 1). This is where your linked server will show up after you add it. Open Tools -> SQL Query Analyzer and paste in the following code: exec sp_addlinkedserver ‘ADSI’, ‘Active Directory Services 2.5′, ‘ADsDSOObject’, ‘adsdatasource’ You should now be able to expand Linked Servers and see [...]