--将老用户的表转到新用户下! declare @objname sysnamedeclare owner_cursor cursor for select name from sysobjects where uid = user_id('老用户名') and type = 'u'open owner_cursorfetch next from owner_cursor into @objnamewhile (@@fetch_status <> -1)begin set @objname = '老用户名' + '.' + @objname exec sp_changeobjectowner @objname, '新用户名' fetch next from owner_cursor into @objname endclose owner_cursor deallocate owner_cursor
declare @objname sysnamedeclare owner_cursor cursor for
select name
from sysobjects
where uid = user_id('老用户名') and type = 'u'open owner_cursorfetch next from owner_cursor into @objnamewhile (@@fetch_status <> -1)begin
set @objname = '老用户名' + '.' + @objname
exec sp_changeobjectowner @objname, '新用户名'
fetch next from owner_cursor into @objname
endclose owner_cursor
deallocate owner_cursor