Perry Whittle (8/16/2012)
Correct you can't drop the user, you change the mapping.
You cannot change the login mapped to the dbo user either...at least I could not on 2005, 2008 R2 or 2012.
Issuing this:
USE [SomeDatabase];
ALTER USER [dbo] WITH LOGIN = [SomeLogin];
On all three versions I get this:
Msg 15150, Level 16, State 1, Line 1
Cannot alter the user 'dbo'.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato