If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Unanswered: Identity defaults to 0

Has anyone ever had the identity seed default for all tables to 0 instead of 1?

I routinely create new databases by copying a detached database (.mdf file), renaming the copy and attaching the new database. I do not normally have any problems with this but when I inserted records into one of the tables of a recently created database the identitfy field started at 0. I tried inserts on several of the other tables and the identity started at 0 as well. I did not reseed or truncate any tables. If I check the design table information or run sp_help for any of the tables it says that the seed is 1 and Not For Replication is 0.

I have tried to recreate this problem by copying the detached database and have been unsuccessful. I cannot change the method of how our company creates these databases and am concerned that this problem may occur again.

I thought that the default for an identity was 1 and could only be changed one table at a time. Is this not true?