Set AutoIncrement to "0"

USE NopNew;
  GO
  DBCC CHECKIDENT ("Nop_Picture", RESEED, 0);
  GO

//nopnew is the database name
// nop_picture is the table name