用一个什么语句可以改变MSSQL表的所有者为DBO

[xiaochun023]

我现在用的是:

exec sp_msforeachtable 'sp_changeobjectowner ''?'', ''dbo'''

但存储过程改不了

想找一个能只改变其所有者,其它如触发器,存储过程不变的方法

[zjcxc]

可以用游标, 无法用一个语句

[CN_SQL]

你在说什么啊?没发现你自相矛盾么?
一会说存储过程改不了,一会说又想存储过程不改变.

[水族杰纶]

declare @tblname varchar(30)
declare @tblown varchar(50)
declare tbl_cur cursor for
select name from sysobjects where uid=5 and status>=0 and xtype in (U,P)
--select * from sysusers
open tbl_cur
fetch next from tbl_cur into @tblname
while @@fetch_status=0
begin
set @tblown=web56433.+@tblname
EXEC sp_changeobjectowner @tblown, chn
print @tblname
fetch next from tbl_cur into @tblname
end
close tbl_cur
deallocate tbl_cur

[utpcb]

declare @tblname varchar(30) 
declare @tblown varchar(50) 
declare tbl_cur cursor for 
select name from sysobjects where uid=5 and status>=0 and  xtype in (U,P) 
--select * from sysusers 
open tbl_cur 
fetch next from tbl_cur into @tblname 
while @@fetch_status=0 
begin 
set @tblown=web56433.+@tblname 
EXEC sp_changeobjectowner @tblown, chn 
print @tblname 
fetch next from tbl_cur into @tblname 
end 
close tbl_cur 
deallocate tbl_cur