Set start value for column with autoincrement

by

From Resetting SQL Server Identity Columns:

Retrieving the identity for the table Employees: 

DBCC checkident ('Employees')

Repairing the identity seed (if for some reason the database is inserting duplicate identities):

DBCC checkident ('Employees', reseed)

Changing the identity seed for the table Employees to 1000:

DBCC checkident ('Employees', reseed, 1000)

The next row inserted will begin at 1001.

More Related Contents:

  1. Local and global temporary tables in SQL Server
  2. Get first day of week in SQL Server
  3. What is the significance of 1/1/1753 in SQL Server?
  4. Cannot truncate table because it is being referenced by a FOREIGN KEY constraint?
  5. SQL Server add auto increment primary key to existing table
  6. How to delete large data of table in SQL without log?
  7. Insert Update trigger how to determine if insert or update
  8. SQL Server: UPDATE a table by using ORDER BY
  9. EF5: Cannot attach the file ‘{0}’ as database ‘{1}’
  10. Do I really need to use “SET XACT_ABORT ON”?
  11. What is a Trusted Connection?
  12. SQL – The conversion of a varchar data type to a datetime data type resulted in an out-of-range value
  13. Do while loop in SQL Server 2008
  14. Connecting to MS SQL Server with Windows Authentication using Python?
  15. Using COALESCE function to make values separated with commas
  16. How to programmatically create an ODBC Linked Table to a SQL Server View and have it be editable?
  17. How to find the port for MS SQL Server 2008?
  18. Assign result of dynamic sql to variable
  19. How do I create a multiple-table check constraint?
  20. Stored Procedure and Permissions – Is EXECUTE enough?
  21. Stored procedure – return identity as output parameter or scalar
  22. SQL Server Group by Count of DateTime Per Hour?
  23. How to import a DBF file in SQL Server
  24. SQL Server Dependencies
  25. SQL Server: Filter output of sp_who2
  26. How can I insert binary file data into a binary SQL field using a simple insert statement?
  27. Why do I get the error “Xml data type is not supported in distributed queries” when querying a linked server for non-xml data?
  28. Cannot find either column “dbo” or the user-defined function or aggregate “dbo.Splitfn”, or the name is ambiguous
  29. SQL Server query to find all current database names
  30. SQL Server 2008 – order by strings with number numerically

Leave a Comment