Thursday, February 07, 2013 2:10 AMi 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.
Thursday, February 07, 2013 2:17 AM
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!!
- Edited by Stan210 Thursday, February 07, 2013 2:23 AM
Thursday, February 07, 2013 2:54 AMNow the user has gone from users list in that particular db. so ok now.
- Marked As Answer by h2007 Thursday, February 07, 2013 2:54 AM