I know it is possible to change the database owner, but am I able to change
the owner of a table as well? Currently, the owner of the database and tables
is EXAV. The problem is for the programmers... this is the only table owned by
anyone other than DBO. We've got some code that is supposed to work
for both tables and it causes them some coding problems because that qualifier
isn't the same. For the tables owned by EXAV, they have to code it EXAV.tablename
and for the tables owned by DBO, they just code the tablename.

Is there anything I can do short of creating a new database and copying the data over?
Thanks for the advice!
Toni Eibner