Re: Can't remove user from role

Hi
What is the version are you using?
I've tried to remove them via sp_droprolemember without success
Did you get any errors?






<cbtechlists@xxxxxxxxx> wrote in message
news:d80f5500-7f2d-42fe-b666-5fbb94c8f46e@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I have a user in a database role that I cannot remove from the role.
If I go into the user's properties and deselect the role, click OK,
then go back in, the role is still checked.

I've tried to remove them via sp_droprolemember without success.

I am able to add and drop the user from other roles, though, and I'm
able to add/drop users to the same role.

What's up with that? How do I drop them from the role?


.