declare @max integer,@id integer
　　declare cur_rows cursor local for select 主字段,count(*) from 表名 group by 主字段 having count(*) > 1
　　open cur_rows
　　fetch cur_rows into @id,@max
　　while @@fetch_status=0
　　begin
　　select @max = @max -1
　　set rowcount @max
　　delete from 表名 where 主字段 = @id
　　fetch cur_rows into @id,@max
　　end
　　close cur_rows
　　set rowcount 0iTbulo . c omOZh1q

　　select distinct * from tableNameiTbulo . c omOZh1q

　　select distinct * into #Tmp from tableName
　　drop table tableName
　　select * into tableName from #Tmp
　　drop table #TmpiTbulo . c omOZh1q

　　select identity(int,1,1) as autoID, * into #Tmp from tableName
　　select min(autoID) as autoID into #Tmp2 from #Tmp group by Name,autoID
　　select * from #Tmp where autoID in(select autoID from #tmp2)iTbulo . c omOZh1q

　　exec sp_changeobjectowner 'tablename','dbo'iTbulo . c omOZh1q

　　CREATE PROCEDURE dbo.User_ChangeObjectOwnerBatch
　　@OldOwner as NVARCHAR(128),
　　@NewOwner as NVARCHAR(128)
　　ASiTbulo . c omOZh1q

　　DECLARE @Name   as NVARCHAR(128)
　　DECLARE @Owner  as NVARCHAR(128)
　　DECLARE @OwnerName  as NVARCHAR(128)iTbulo . c omOZh1q

　　DECLARE curObject CURSOR FOR
　　select 'Name'   = name,
　　'Owner'   = user_name(uid)
　　from sysobjects
　　where user_name(uid)=@OldOwner
　　order by nameiTbulo . c omOZh1q

　　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,@OldOwneriTbulo . c omOZh1q

　　FETCH NEXT FROM curObject INTO @Name, @Owner
　　ENDiTbulo . c omOZh1q

　　close curObject
　　deallocate curObjectiTbulo . c omOZh1q

　　GOiTbulo . c omOZh1q