数据库打开新建查询 选择对应的数据库 把下边代码复制执行 错误忽略！OK

declare tb cursor local for

sp_changeobjectowner [+replace(user_name(uid),],]])+].[

+replace(name,],]])+],dbo

from sysobjects

where xtype in(U,V,P,TR,FN,IF,TF)status>=低

open tb

declare @s nvarchar(4低低低)

fetch tb into @s

while @@fetch_status=低

begin

exec(@s)

fetch tb into @s

end

close tb

deallocate tb

go