Post reply

Change all of your database owners

  • September 7, 2010 at 9:05 pm

    #240097

    Comments posted to this topic are about the item Change all of your database owners


    thanks, ERH

  • September 8, 2010 at 9:00 am

    #1218011

    Worked Perfect !!!

  • September 8, 2010 at 10:12 am

    #1218077

    I appreciate your script, but I've seen problems in SQL 2000 where the login that was the DB owner lost it's access rights after doing this and took down applications as a result. Have anyone had similar experiences and could you please comment on how you resolved it?

    Thanks to all for your responses. 🙂

    Drive it like you stole it[/size] :w00t:

  • September 9, 2010 at 9:24 am

    #1218718

    Hi E. Hendrix

    I am not sure just what this script does. Does it generate the sql to make the change or does it actually make the change ?

    Do you have sample output ?

    Thanks

    jim

  • September 9, 2010 at 9:42 am

    #1218730

    This executes. I executed on a SQL Server 2005 database server with 5 databases and all "user" databases where changed to "sa".:-)

  • September 9, 2010 at 1:53 pm

    #1218871

    I agree you should know your application before you do this. In most cases this should not cause issues especially using SA. That is unless you have SQL Auth turned off then I'd suggest a service account that you use to start the SQL Server Service and/or Agent.

    I do know that in older versions of sharepoint you may run into issues if sharepoint expects the database owner to be the same account that runs the sharepoint farm. In that case though you may have bigger issues since that would mean the person who left your company also owns your sharepoint web servers in the farm so good luck with that.


    thanks, ERH

  • September 9, 2010 at 1:55 pm

    #1218873

    This one walks through each database, non-system, and changes the owner. You should simply see a list of your databases it executed against in your output.

    I would suggest you run 'sp_helpdb' before you run this to capture the current owners....just in case you need to go back.


    thanks, ERH

  • November 8, 2010 at 9:37 am

    #1247732

    There are plans to remove sp_changedbowner. you can replace with

    alter authorization on Database::"dbname" to "username"

  • May 18, 2016 at 7:14 am

    #1879860

    Thanks for the script.

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply