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

7May/085

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

Reference for me. Reference for you.

sp_MSforeachtable @command1="EXEC sp_changeobjectowner '?','dbo'"

Posted by: Chrissy Filed under: SQL Server Leave a comment

WebDevBB
September 9th, 2008 - 16:27

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.

( REPLY )
Robert
October 12th, 2008 - 23:43

Thank You

Very Useful

( REPLY )
ben
March 26th, 2009 - 17:08

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

( REPLY )
Alex
January 13th, 2010 - 19:35

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.

( REPLY )
Steve
May 18th, 2011 - 05:51

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

( REPLY )