Microsoft SQL Server 中修改数据库对象所有者
批量修改:
EXEC sp_MSforeachtable 'exec sp_changeobjectowner "?","dbo" '
单个修改:
exec sp_changeobjectowner '要改的表名','dbo'
EXEC sp_MSforeachtable 'exec sp_changeobjectowner "?","dbo" '
单个修改:
exec sp_changeobjectowner '要改的表名','dbo'
