sql导出数据库时报 "登陆 xxx 失败",无法完成

修改数据库对象所有人
今天帮朋友传数据库报错,提示 "
[Microsoft][SQLServer 2000 Driver for JDBC][SQLServer]登陆 xxx 失败",正好前段时间碰到同样问题,尝试删除用户 xxx , 又报错,提示" 用户拥有对象,所以无法删除". 查看数据库,发现该用户拥有很多存储过程,一个一个改太麻烦,从网上找到如下方法,恰好解决此问题:
CREATE   PROCEDURE   dbo.User_ChangeObjectOwnerBatch  
  @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  
  -- select   @name,@NewOwner,@OldOwner  
   
  FETCH   NEXT   from   curObject   INTO   @Name,   @Owner  
  END  
   
  close   curObject  
  deallocate   curObject   
        
  GO  
然后执行存储过程即可
exec User_ChangeObjectOwnerBatch