Friday, 5 December 2014

Reseed allocated incremental id in sql

Select * from dbo.SpExecutionAuditContorl Where iStep>21 
delete from dbo.SpExecutionAuditContorl  Where iStep>21 

DBCC CHECKIDENT('dbo.SpExecutionAuditContorl', RESEED, 21)

No comments:

Post a Comment