Change owner of many MS SQL tables

Posted At : May 30, 2008 3:02 PM | Posted By : Mark W. Breneman
Related Categories: ColdFusion

The internet is really in impressive reference library. I needed to change the ownership of 78 SQL tables. I was not about to click through 78 tables via the enterprise admin GUI to change ownership. I thought about getting a list of the tables and hacking together a SQL script to change the ownership with sp_changeobjectowner. Then I came across this technique the combined sp_changeobjectowner with sp_MSforeachtable.

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

I found this and several other ways to change owner of many MS SQL tables at:
http://joseblanco.blogspot.com/2004/10/change-owner-of-all-tables-in-sql.html

Comments (0) | Print | Send | del.icio.us | Digg It! | Linking Blogs | 761 Views
Comments (Comment Moderation is enabled. Your comment will not appear until approved.)

There are no comments for this entry.

[Add Comment]
BlogCFC was created by Raymond Camden. This blog is running version 5.9.001. Contact Blog Owner