When attempting to drop a database user, you get the following message:
One place to begin is your stored procedures. The database user has likley been used in the “WITH EXECUTE AS” option in a stored procedure:
Hey, didja know that RedGate SQL-Search is FREE! Hint! Hint! Go get it. It will be a BIG help in this case.