Results 1 to 6 of 6

Thread: change DB owner

  1. #1
    Join Date
    Mar 2004
    Posts
    99

    Unanswered: change DB owner

    I have several Production Databases on my SQL Server 2000 Standard Edition Server (mixed mode authentication) that I'd like to change DBO Permissions on. When I look at the Properties of the DB(s) from EM, the Database owner is showing up as a Windows NT USer who is no longer even with the company!!

    Can I use the sp_changedbowner 'sa' command to change the database owner to sa without disrupting Production? Might sound like a dumb question.. but ya never know!!!!! Also, I had someone on another forum tell me that 'sa' as db owner is a bad idea but I don't know why??????? can anyone elaborate on that?????

  2. #2
    Join Date
    Sep 2004
    Location
    Birmingham, UK
    Posts
    18
    I am also interested in these questions (and so have posted to just put it back to the top of the list in the hope someone can answer - is that bad etiquette?)

  3. #3
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Yes, you can always change the database owner to sa. At least as far as I know, this is a good idea in almost every case.

    As far as the person that thought it was a bad idea, I'd love to hear their reasoning... While I can concoct a case where it was a bad idea, it would take some considerable doing, and would probably never happen in "the real world".

    -PatP

  4. #4
    Join Date
    Sep 2004
    Location
    Birmingham, UK
    Posts
    18
    Thank's Pat.

    jpotucek, even though the user that own's the database has left, does their Windows account still exist? Does it cause you any issues?

  5. #5
    Join Date
    Mar 2003
    Location
    Indiana, USA
    Posts
    100
    The only reason I ever had a person other than sa as dbo, was when I had a person who kept forgetting to put dbo in front of objects she created.

    Tim S

  6. #6
    Join Date
    Mar 2004
    Posts
    99
    I don't manage the NT accounts here, just the logins on the SQL Server. The accounts still exist and they may even be disabled, i don't know. I'm going to change the DB Owner on all to sa and drop the users from my sql servers - then I know i won't have any problems!!!!

    THank you one and all

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •