Identity

hi all,

is it somehow possible to reset the identity number for a table
before starting a bulk insert ?
What i want to do is to have a column start counting for a
given insert. If i do another bulk insert i want that column start by 1.
Right now i have set that column to identity (yes) .

thx in advanceWhat do you plan to do with the existing data?

Look up

DBCC CHECKIDENT

in BOL