Your sql server user id must have sufficient authority to reset an identity seed. if you are the table's owner, this grants the authority, as does a sysadmin or db_ddladmin user type.. Reset identity value. ask question now when you truncate the table, it will reset the identity value to its original seed value of the table. refer to : sql server � delete, truncate and reseed identity for a detailed example and some good explanation of difference between truncate and delete.. Reset identity column value in sql server. lowell heddings @lowellheddings march 7, 2007, 1:06pm edt. if you are using an identity column on your sql server tables, you can set the next insert value to whatever value you want. an example is if you wanted to start numbering your id column at 1000 instead of 1..
Applies to: sql server (starting with 2008) azure sql database azure sql data warehouse parallel data warehouse returns the original seed value (returned as numeric ( @@ maxprecision,0)) that was specified when an identity column in a table or a view was created.. Sql server � delete, truncate and reseed identity august 24, 2012 pinal dave sql , sql server , sql tips and tricks 69 comments yesterday i had a headache answering questions to one of the dba on the subject of reseting identity values for all tables .. Use the linq to sql executecommand to run the required sql. db.executecommand("dbcc checkident('table', reseed, 0);"); linq is a data-source agnostic query language and has no built-in facilities for this kind of data-source specific functionality..
