DBCC CHECKIDENT (tablename, RESEED, <seed value>)

> Is it possible to reset a  Identity(autonumber in Access) column in SQL
> server?
> If i delete some records, the identity column holds previous content.
> Thanks.