>Hi All,
> I have a primary key in one of my table. When the record is added the primary key is increased to next number. I have been testing and the primary key is 100, however my client want the primary to start to one. Thus, is there a way that would allow me to reset the primary key back to 1.
>
>Thanks, this will save me .
I think you can use "Truncate Table" or "DBCC CHECKIDENT".
ICQ 10556 (ya), 254117