如何更改表的所有者权限
批量更改:
exec sp_msforeachtable 'sp_changeobjectowner ''?'',''dbo'''
单个表更改:
exec sp_changeobjectowner '[admin888].[Employee]','dbo'
exec sp_msforeachtable 'sp_changeobjectowner ''?'',''dbo'''
单个表更改:
exec sp_changeobjectowner '[admin888].[Employee]','dbo'