--修复自增列：
use stdssv10--数据库名请根据修复的数据库进行跟换,如果是分部则为 hbposv8_branch
go
declare @tablename varchar(100)
declare test_cur cursor for
select object_name(id) from syscolumns
where status=128
open test_cur
fetch test_cur into @tablename
while @@fetch_status=0
begin
 DBCC CHECKIDENT (@tablename, RESEED)
 fetch test_cur into @tablename
end
close test_cur
deallocate test_cur
go