Home Dashboard Directory Help

Datadude: Change DB owner by Jamie Thomson


 as Won't Fix Help for as Won't Fix

Sign in
to vote
Type: Suggestion
ID: 286032
Opened: 7/3/2007 10:37:21 PM
Access Restriction: Public


For some reason my DBA wants all databases to be owned by sa. Apparently this is best practice. I don't question - I'm not a DBA.

Currently datadude doesn't ask the user to specify a DB owner in the databsae properties and then issue a call to sp_changedbowner. perhaps it should.
Sign in to post a comment.
Posted by Guy_1 on 11/15/2007 at 12:13 PM
Definitely needed. Changing the owner after the database is created from backup is not easy if the new owner already exists as a user in the database.
Posted by Microsoft on 7/18/2007 at 10:33 AM
Thank you for the suggestion. We will consider this feature when planning future releases.

Team System Data Team
Posted by Microsoft on 7/4/2007 at 3:15 AM
Thanks for your feedback. We have routed this suggestion to the appropriate group within the Visual Studio Product Team for triage and resolution.

Thank you,
Visual Studio Product Team.
Sign in to post a workaround.