I connected to the SQL Server Instance inside SQL Server Management Studio and found that under Database A - Security �?? Users �?? MyUserName �?? Database User - Role Membership, db_owner is not checked. As a matter of fact no boxes are checked at all. I tried to check db_owner but I get a message saying I do not have permissions to do this. Our IT Dept has permissions, I can ask them to "check the box".
Database A = the database I am trying to figure out if I have db_owner role.
MyUserName = is my user account name
It appears that I am not the db_owner? this could be the reason why I cannot do anything other than make a connection to the database Instance inside ArcCatalog.
Note I am using the dbo schema (not sde).
You provided me the command line info, I believe I got the same info from SQL Server Management Studio.