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 >