Reseeding in SQL Server gets different results based on whether the table has ever had data in it.
ref: http://cs.thycotic.net/blogs/bryant_smith/archive/2006/01/17/65.aspx
I am having the same problem. Any suggestions ?
Are you asking how to reset the identity seed count after you delete the data from a table and you want to start over again with a new count? If so here is the code...
Example:
use Database
DBCC CHECKIDENT ('[Scheme].[Table]' , RESEED, 0)
