Is there any way to write a procedure that will return the names of NT user accounts & group memberships? I would like to write a sp that would run each night, collecting the names of all the NT users who have been added to a particular group, and storing them in a SQL table. I use SQL 6.5 and NT 4.

Our domain admins frequently add users to an NT group which gives them access to my database. But they can delete the account or remove the group membership, leaving me with no record of who got access to the db and when. I need something that will run as a scheduled task--I can't do this manually.

Thanks,

Ross