[MSSQL]批量修改表及储蓄过程的所有者方法

--EXEC sp_changeobjectowner 'ltd.News', 'dbo'
DECLARE @name varchar(200)
DECLARE @owner varchar(50)
DECLARE @xtype varchar(50)
DECLARE @buff varchar(200)


DECLARE curObject CURSOR FOR
select name,
user_name(uid),xtype
from sysobjects
where user_name(uid)='zqoa' and xtype = 'P' and name not like 'dt_%'
--order by name



OPEN curObject
FETCH NEXT FROM curObject INTO @name, @owner,@xtype

WHILE(@@FETCH_STATUS=0)
BEGIN
   set @buff = ''
   set @buff = 'zqoa.'+@name
   --print @name
   exec sp_changeobjectowner @buff ,'dbo'
   FETCH NEXT FROM curObject INTO @name, @owner,@xtype
END

close curObject
deallocate curObjec
go


--exec sp_changeobjectowner "zqoa.zq_fc_Moudle" ,'dbo'

转载于:https://www.cnblogs.com/niuniu502/archive/2007/09/27/908493.html