uanble to assign a db_owner role to sa for a particular DB

[arshadmqureshi]

I have a database named as test_db. Iam trying to assign a db_owner role to the test_db. But it won't allow me to assign the role and give the error "CANNOT USE THE SPECIAL PRINCIPAL 'DBO' (MICROSOFT SQL SERVER ERROR 15405)".

Can any one help me in this regard.

Arshad

[ck9663]

If you're trying to assign yourself as dbo on your database, it won't work coz you're already the dbo. You can't add db_owner to it anymore.

Good Luck!!!

~~ CK

[arshadmqureshi]

Many thanks CK. Actually what i ma trying to do is restore a database from sql server 2000 to sql server 2008 64 bit. After restoration the said database have 0 roles / schemas. we create roles and schemas manually and assign the user mapping to that particular database. when we execute the sql statement "SELECT IS_MEMEBER ('DB_OWNER')" the query returns the value zero. Actually it must return the value 1. because of this we are unable to create publication. Because when we try to create the publisher at the end of wizard it give us an error "YOU DO NOT HAVE THE REQUIRED PERMISSION"

Please help in this regard.