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...

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