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

Filed under: SQL Server — Written by Chrissy on Wednesday, May 7th, 2008 @ 6:32 pm

Reference for me. Reference for you.

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

No comments yet. Be the first to comment this post.

RSS feed for comments on this post. TrackBack URL

Leave your comment