更改数据库对象所有者

 

 declare cur cursor for

select name from sysobjects where uid=user_id('net4646608') and (xtype='U' OR xtype='P')

declare @name sysname

declare @sqlstr varchar(5000)

open cur

fetch next from cur

into @name

while @@fetch_status=0

begin

set @sqlstr='exec sp_changeobjectowner ''net4646608.'+@name+''',''dbo'''

exec (@sqlstr)

fetch next from cur

into @name

end

close cur

deallocate cur

/* 原来数据对象的所有者：dbo 修改后新的对象所有者：new */