TSQL - Reset identity column value for a table

Post date: Feb 14, 2010 11:45:07 AM

DBCC CHECKIDENT (orders, RESEED, 999)