MS SQL 2000/2005 修改表所有者存储过程

Create PROCEDURE [dbo].[ChangeObjectOwner]
@OldOwner as NVARCHAR(128),
@NewOwner as NVARCHAR(128)
AS
DECLARE @Name   as NVARCHAR(128)
DECLARE @Owner  as NVARCHAR(128)
DECLARE @OwnerName as NVARCHAR(128)
DECLARE curObject CURSOR FOR
select 'Name' = name,
 'Owner'   = user_name(uid)
from sysobjects
where user_name(uid)=@OldOwner
order by name
OPEN  curObject
FETCH NEXT from curObject INTO @Name, @Owner
WHILE(@@FETCH_STATUS=0)
BEGIN   
if @Owner=@OldOwner
begin
  set @OwnerName = @OldOwner +'.' + rtrim(@Name)
  exec sp_changeobjectowner @OwnerName, @NewOwner
end
FETCH NEXT from curObject INTO @Name, @Owner
END
close curObject
deallocate curObject
------------------------
说明：以上代码只需要在存储过程中新建执行即可，但是第一次执行回出现警告和错误说明，
如果你的asp.net程序执行出现以下类似错误，那说明你的现有的试图或存储过程中的表对象没有改过来，需要修改视图或者存储过程；
对象名  'wzuhll.HomeWork_List' 无效。
由于绑定错误，无法使用视图或函数 'VIEW_hw_studentlist'。