login properties - cannot alter the user 'dbo'

I'm using Sql Server Express 2008 and trying to set the login properties for a database I just attached.

I selecrted my login user went to the server mappings and when I click okay, I get the error:

"Cannot alter the user 'dbo'"

Any help is appreciated.
Thanks.
-Dman100-Asked:
Who is Participating?
 
Raja Jegan RConnect With a Mentor SQL Server DBA & ArchitectCommented:
Use sp_changedbowner to a new user or sa like this to fix it out..
Eg:

exec sp_changedbowner 'sa'

or some other login instead of sa to fix it out.
0
All Courses

From novice to tech pro — start learning today.