在数据库中改变对象的所有者

打印本文   关闭窗口

在数据库中改变对象的所有者

作者：未知  文章来源：网络收集  点击数   更新时间：2006-3-10 14:16:36

查出不是dbo的所有对象 select sysobjects.name,sysusers.name from sysobjects ,sysusers where sysusers.uid=sysobjects.uid and sysusers.name<>'dbo' 产生SQL 语句 select 'EXEC sp_changeobjectowner '''+ sysusers.name+'.'+sysobjects.name +''',''dbo''' from sysobjects ,sysusers where sysusers.uid=sysobjects.uid and sysusers.name<>'dbo' 查出不是dbo的所有对象 select sysobjects.name,sysusers.name from sysobjects ,sysusers where sysusers.uid=sysobjects.uid and sysusers.name<>'dbo' 产生SQL 语句 select 'EXEC sp_changeobjectowner '''+ sysusers.name+'.'+sysobjects.name +''',''dbo''' from sysobjects ,sysusers where sysusers.uid=sysobjects.uid and sysusers.name<>'dbo'