Set start value for column with autoincrement

Question

I have a table `Orders` with the following fields: Id | SubTotal | Tax | Shipping | DateCreated The `Id` column is set to `autoincrement(1,1)`. This is to be used in an E-commerce storefront. Sometimes a current E-commerce store is migrated to my platform and they already have orders - which could mean that their current `Order.Id` is, for example, `9586`. I want to have the `autoincrement` field start from that value. How can I do this?

Accepted Answer

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.

Set start value for column with autoincrement

Solution

Problem