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

打印本文   关闭窗口

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

作者：未知  文章来源：网络收集  点击数 <script language="javascript" src="file:///G:/Documents%20and%20Settings/jhtest/桌面/打印文章在数据库中改变对象的所有者_files/GetHits.htm" type="text/javascript"></script>   更新时间：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'