Rebuilding an index and resetting an identity column are two different
things.... you may rebuild indexes whenever you wish...
To reset the identity column use dbcc check_ident. It is doented in books
"SAlva" <sgomezNOSPAMMINGPLEASEhotetur.com> wrote in message
news:039e01c33ef3$19c5e300$a001280aphx.gbl...> hi all,
> in access we have an "utility" to rebuild autonumeric
> index when a table is empty(Set the autonumeric to the
> first available number,erasing the previous index). How
> can I do it in SQL?