Also, error 7321 indicates that it is a rights, permissions issue. see:

http://help.wugnet.com/windows2/SQL-AD-Security-Query-AD-Database-ftopict517188.html

I did try your query, substituting our Domain name and it ran sucessfully.

Does your domain have two names? Like kmhg.kmma.net? If so you need three DC=...

Have you tried creating a view to AD? You can use the following:

CREATE VIEW [vADUsers] AS

SELECT samAccountName AS TM_Number

,displayName AS Workstation_User

,Department

FROM OPENQUERY(ADSI, '

SELECT samAccountName,...

Please post the error message you receive. Might be a rights issue. Are you on the right domain?

It would help to see the code you are using to...

Thanks, Steve. I was thinking along the same lines. I'll see if management will go along. If not, I may still need some help.

Management wants the inventory database complete. They are leasing computers and have a need to know who has what computer and their location. We are leasing around 2500...

Michael - Thank you very much! That's exactly what I was looking for. Works great.

Thanks ps for your quick response and script. Since the table already exists and populated, I

just want to open the Enterprise Manager, right-click on Design Table, and select...

I believe that OEM refers to Original Equipment manufacture. It's like a site license. It's a full-up version but you don't get the manuals, etc. The Retail...

I have been chasing my tail! SSIS is not available with SQL2K5 Express.

http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

Victor - be sure to select the events tab and filters if you want. I just installed and am pleased with the performance. As mentioned, not as robust...

Sounds like the problem I had last week connecting to SQL 2K5 via Crystal Reports XI. The SQL Browser fixed my problem. (Here is the URL if you...

Take one coin from stack 1, two coins from stack 2, three coins from stack 3, etc. Weigh them and do the math. The amount over 5.5Lb. will...

Eureka! Jeffery, your suggestion for turning on the SQL Browser service took care of the problem. I connected so fast it was unbelievable! Crystal Reports works fine...

Yes. The HMM-123 reflects workstations whereas HMM123 (no -) represents servers. So, HMM-123\SQLEXPRESS is a workstation and HMM123\SQLEXPRESS is a server. Sorry for the confusion.