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.
You don't really need the db_owner to create/load data in that sde geodatabase. The following permissions will suffice as well: CREATE FUNCTION CREATE PROCEDURE CREATE TABLE CREATE VIEW
To check what permissions your login has right now, Connect to the Instance in SQL Server-->R-Click on the database-->Permissions-->Select your user from the list-->Effective----This will list all the permissions that the login has on that database