Viewing 2 posts - 1 through 2 (of 2 total)
From SQL Server Books Online...
DBCC CHECKIDENT ('table_name', RESEED, new_reseed_value)
Enjoy!
Andrew
August 9, 2005 at 11:12 pm
#580906
If you're trying to achieve this programmatically you will either have to plough through the system tables or INFORMATION_SCHEMA views, or use the Script method of a SQL-DMO Table object.
You...
August 8, 2005 at 9:55 pm
#580588