unfortunately i don't know the history of this db.
What is the value of dbi_createVersion
when you run this? The number will reveal on which version of SQL Server the database was originally created.
DBCC TRACEON (3604);
DBCC DBINFO ('your_database');
i was trying to recreate this scenario on a test server but i was unable to map/alias a user as dbo since that account exists in all of the dbs (sql 2008), so i too assume that the problem db may have been upgraded from older versions.
sa is mapped to dbo and you cannot change that in SQL 2005 and above, and a user can only be mapped to one login.
transferring dbo schema ownership as suggested above is also an option, and i wanted to transfer it to a 'dbo' user account as this seems to be the sql 2008 standard, but this user account is already aliased as the dbo, so i'm looking for a way to unmap it.
i'm looking at trying drop alias but don't want to risk losing the dbo schema.
You cannot drop the dbo user.
What was the result of the query in my previous post?
__________________________________________________________________________________________________There are no special teachers of virtue, because virtue is taught by the whole community. --Plato