Chowdary's (9/19/2014)
Thank you for your Reply @Gail,I am trying to remove the db_owner role to that Login but it is showing an error like
"Cannot Use the Special Principal 'dbo' ",
I cannot able to remove and also not assign the other db role to him same error am getting......
The user owns the database, in this scenario the user maps in via the dbo database user.
Post the results of the following query
SELECTSUSER_SNAME(owner_sid)AS DatabaseOwner
, nameAS DatabaseName
FROM sys.databases
WHERE name = 'yourdb'
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉