deleting user from sql server 2012

Question

i have deleted login from sql server 2012. But i can't delete from one of the databases. I can see user in Security -> users list. But if i try to delete it says it does not exists on server. Othere databases i was able to delete that user. only one db is giving problem.

---

h2007

Answer 1

ok. let's make sure the user exists,one more time..run this on the database and see if that user is returned

select * from sys.database_principals

if exists, try drop user <<username>>, if it owns any schema, you have to drop or change the owner of it. 

Let us know.

---

Hope it Helps!!

Answer 2

Now the user has gone from users list in that particular db. so ok now.

---

h2007