Ali Parvaresh Blogging from Iran
Run this command against your database:
exec sp_MSforeachtable 'IF OBJECTPROPERTY(OBJECT_ID(''?''), ''TableHasIdentity'') = 1 BEGIN DBCC CHECKIDENT (''?'',RESEED,0) END'
Print | posted on Sunday, February 14, 2010 7:47 AM