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 2000 Forums
 SQL Server Development (2000)
 Active Directory Users

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2003-10-13 : 08:21:25
Murthy writes "is there a solution to import Win2K active directory users to SQL Server2000 ?"

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-10-13 : 12:32:58
sp_grantlogin

You will probably need to call the ADS API to get the list of users. Then just call sp_grantlogin for each user returned.

sp_grantlogin is documented in SQL Server Books Online.

Tara
Go to Top of Page
   

- Advertisement -