[dba-SQLServer] Change db Owner

Arthur Fuller artful at rogers.com
Fri Mar 11 13:15:47 CST 2005


Is there a simple slick way to do this? I have browsed and searched BOL 
and done various other things, finally resorting to these steps (which 
work):

1. create a new db owned by the desired new owner
2. create a DTS package that exports the data from old_db to new_db
3. run it

This sucks. I want something as simple as sp_changeobjectowner, which 
allows you to change the owner of a database object, but not the db itself.

Arthur

>



More information about the dba-SQLServer mailing list