Can't delete user in SQL 2005 management studio

when i trying to delete the user in SQL 2005 management studio database, it appear error message :

Deleting server logins does not delete the database users associated with the logins. To complete the process, delete the users in each database. It may necessary to first transfer the ownership of schemas to new users.

please advice

This is not really an error message, but more of a warning. You have deleted the “main” entry for that login, but there may still be a reference for the login in each database that the login was mapped to on that SQL Server instance. You should look at each database and remove the login if it appears there in the list of logins.

Hi Peter,

actually the warning already tells you what to do: Check the security-directory for every database for entrys of that specific user and delete them im found.



thanks Jan