removing a logon/user from a server & all databases

[smsinger3]

Hello all. I am trying to completely remove someone from sql server, then add him back through EM. I can remove both the logon and user from EM, but when I try to add him back it says the "User or Role already exists in the current database". So, I then ran

exec sp_droprolemember 'rol_name', 'user_id'

This works for everything except the "public" role. How can I remove this person from the database so I can add him back?

Thanks for your help in advance.

Steve S
sms@hmbnet.com

 

[aalmeida]

On SQL 7 and 2k You can use sp_RevokeDbAccess that should take care of it AL Almeida
NT/DB Admin
"May all those that come behind us, find us faithfull"