我使用这个命令
DBCC checkident ('tablename', reseed, 200000000);
但是我有超过150个表...
DBCC checkident ('tablename', reseed, 200000000);
但是我有超过150个表...
sp_MSforeachtable
http://weblogs.sqlteam.com/joew/archive/2007/10/23/60383.aspx。EXECUTE sp_MSforeachtable 'DBCC checkident ([?], reseed, 200000000)';