Developer Forum

by **John M. Sn** » Thu, 12 Feb 2004 01:39:54

Is there a way using T-SQL (or any other way) to change
the "Identity Seed" value of a field in a table.

by **Paul Ibiso** » Thu, 12 Feb 2004 05:24:36

DBCC CHECKIDENT,
eg
USE pubs
GO
DBCC CHECKIDENT (jobs, RESEED, 30)
GO
Regards,
Paul Ibison