I really need to write a full post as to why you’d seed your Umbraco tables. The main reason is to split the content from the CMS setup/structure. This means you could release your changes via a custom toolset or move content between installations.
Remember for ease you must do this with a blank Umbraco database – that is just after install.
DBCC CHECKIDENT (cmsContent, reseed, 100000000) DBCC CHECKIDENT (cmsContentVersion, reseed, 100000000) DBCC CHECKIDENT (cmsPropertyData, reseed, 100000000) DBCC CHECKIDENT (umbracoNode, reseed, 100000000)
Then you may want to select on those tables just to check.
SELECT IDENT_SEED(TABLE_NAME) AS Seed, IDENT_INCR(TABLE_NAME) AS Increment, IDENT_CURRENT(TABLE_NAME) AS Current_Identity, TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE OBJECTPROPERTY(OBJECT_ID(TABLE_NAME), 'TableHasIdentity') = 1 AND TABLE_TYPE = 'BASE TABLE'