Sql 更改表名，SQL2000批量更改表所有者 的方式

1：Sql 更改表名

EXEC sp_rename 'TBVoice', 'TBVoices';

2：SQL2000批量更改表所有者 

@:创建存储过程。

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
GO 

@执行存储过程

DECLARE    @return_value int

EXEC    @return_value = [dbo].[ChangeObjectOwner]
        @OldOwner = N'sunny',
        @NewOwner = N'dbo'

SELECT    'Return Value' = @return_value

GO

@刷新表 即可看到结果