how to reset an identity column programatically (VB)

[San]

how to reset an identity column programatically

Hi,
Is there a way to reset an identity column programatically to a required number?

Regards,
San

 

[Robby]

In SQL Server or ?

 

[San]

yes it is with sqlserver 2000

 

[a_jam_sandwich]

How about removing the column and reinserting it.

Andy

 

[JABE]

You can use DBCC CHECKIDENT as in:

DBCC CHECKIDENT (YourTable, RESEED, StartNumber)

After command, next INSERT will generate identity of StartNumber + 1. Works w/ SQL 7 and above, not sure w/ earlie versions.