I'm working with an existing MS SQL Server database. The database uses Identity type fields for the primary keys.
I've written an app that imports data from a CSV file, but I need to reseed the primary key field to 0 when importing the data. Has anybody reseeded such a field type via SqlDB? Is it possible?
Anybody know if I can execute something like the following via SqlDB:
DBCC CheckIdent(<tablename>, RESEED, 0)
Alternatively, what about the ability to run this:
set identity_insert <table> on|off
so I can populate the identity field with my own auto-increment number?
I would prefer the RESEED option, but either one would do really.