[dba-SQLServer] Change db Owner

Haslett, Andrew andrew.haslett at ilc.gov.au
Sun Mar 13 17:56:43 CST 2005


Would you like us to kick you, or would you like to do it yourself?  ;=)
 
How about:  sp_changedbowner
 
Cheers,
A

________________________________

From: dba-sqlserver-bounces at databaseadvisors.com on behalf of Arthur Fuller
Sent: Sat 12/03/2005 5:45 AM
To: dba-sqlserver at databaseadvisors.com
Subject: [dba-SQLServer] Change db Owner



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

>
_______________________________________________
dba-SQLServer mailing list
dba-SQLServer at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
http://www.databaseadvisors.com





More information about the dba-SQLServer mailing list