存储过程-循环更改所有者

alter proc test
as
begin
        declare @name nvarchar(80)
        --声明一个游标，根据@bmdm选择其下级的部门
        declare cursor_bmTable cursor for  
        SELECT name from sys.objects
        WHERE type='U'
        --order by i_xh for read only
       
        open    cursor_bmTable  
        fetch cursor_bmTable into @name  
       
        --当执行成功时
        while @@fetch_Status=0  
            begin
    set @name='eOffice.'+ @name
               exec sp_changeobjectowner @name,'dbo'
               fetch cursor_bmTable into @name
            end
        close      cursor_bmTable    --关闭游标
end