SQL Server: Change the Owner of All Tables to "dbo"

Reference for me. Reference for you.

sp_MSforeachtable @command1=”EXEC sp_changeobjectowner ‘?’,’dbo'”

Chrissy is a Cloud and Datacenter Management & Data Platform MVP who has worked in IT for over 20 years. She is the creator of the popular SQL PowerShell module dbatools, holds a master's degree in Systems Engineering and is coauthor of Learn dbatools in a Month of Lunches. Chrissy is certified in SQL Server, Linux, SharePoint and network security. You can follow her on Twitter at @cl.

Posted in SQL Server
5 comments on “SQL Server: Change the Owner of All Tables to "dbo"
  1. WebDevBB says:

    Hi Chrissy… Thanks very much for this. I wish I had seen your post before. I had a need for this script a couple days ago but at least I have it now. :)

  2. Robert says:

    Thank You

    Very Useful

  3. ben says:

    you rock. curls, ninjas, and SPROCS. its what dreams are made of!
    thank you!

  4. Alex says:

    Hi Chrissy, i’m having a problem to delete or rename a database, i want to delete it manually, but it says i don’t have permission, can you help me please :(.

    Thank you.

  5. Steve says:

    This is one of the most useful pieces of SQL script I have ever come across! Thank you so much!

Leave a Reply