>Hi All,
> I have a column field that has a identity increment set to 1
>After i insert few records the value increase ...but after i delete all the records and insert again...the value are not back to 1
>How can 1 change the value back to 1 ??
>
The TRUNCATE TABLE command resets identity to the seed for the column. If for some reason you cannot use it, take a look at DBCC CHECKIDENT in BOL.
--sb--