change all tables to dbo owner
Here is a sql server script I found that will change all tables to the dbo owner.
sp_MSforeachtable @command1=”EXEC sp_changeobjectowner ‘?’,’dbo'”
Published by admin on December 6, 2008 11:37 am under Database / Sql
Here is a sql server script I found that will change all tables to the dbo owner.
sp_MSforeachtable @command1=”EXEC sp_changeobjectowner ‘?’,’dbo'”
Copyright © 2024 Gray Wolf Blog
WordPress Theme based on Light Theme
Trackback URI |