May 19, 2008 at 12:05 pm
HEY Guys
i need to remove more than 50 logins and users from perticular Database , what is best way to do it using script or any other method . because i am following one method which is going every login check for mapping remove them and delete login.but it making me to get too much pain,
Please provide if any one have script or other idea.
May 19, 2008 at 1:27 pm
Personally, I'd probably do it by hand to make sure I didn't miss anything. The way to avoid this in the future is create groups, instead of setting up each individual login in each database.
- 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
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply