If it's SQL Server, adding an identity column should auto seed it as if it were always there. I've had to do this numerous times in the past with SQL2k and I just tested it in 2k8 R2.
From: Charles Carroll <911@...
Sent: Tuesday, January 24, 2012 4:24 PM
Subject: [SQLQueriesNoCode] Co-worker forgot id field
so when he adds the field all existing rows have a 0 value.
How do I get the 1000s of existing rows to get numbered after the fact...
did not help
[Non-text portions of this message have been removed]