You should be able to query AD data at runtime, instead of trying to keep it in SQL tables. That way, you don't have to worry about the data getting out of synch or anything like that. You can set up a linked server to the AD server, and query that.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon