Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2005 Forums  Transact-SQL (2005)  can I Select directly from Active Directory?

Author  Topic  OMomani Starting Member 2 Posts Posted - 2008-09-15 : 06:16:07 dears, i have a table in my database, this table contains UserIDs (e.g. OMomani@eSesnseSoftware is the userID for me Osama Momani in the active directory) so my table contains only UserIDs, and in my website i need to render those users from my table but i want to render their names not their IDs! i can get the UserIDs and in my application i iterate through the UserIDs and get the Active Directory objects corresponding to the given UserID to get his Name. i have to do this for each UserID. Performance is so down!!!!!! what am looking for, is a way to select the userIDs from my table and also select the correponding name from active directory in one Stored Procedure! is it doable?? and how?