I have create a new table on SQL Server 2008.
This table has an identity column, defined like this:
[ID] [int] IDENTITY(1,1) NOT NULL
However when I insert any data, the first record starts from 0, instead of 1.
I want the records to start from 1. Why does this not work?
If I delete the record and reseed it to 0, it works.
Delete from [tablename] DBCC CHECKIDENT('[tablename]', RESEED, 0)
However it does not work on newly created tables.
Even if I delete and reseed a newly created table, it still starts adding record from 0, instead of 1.
Can you anyone please suggest what I am doing wrong.