Hi there - I fotched up a SQL Server 2000 table definition while
recovering from a server crash, and now I have a situation where the
identity (key) field for table A with 20M recs was accidentally set to
non-identity and saved. I've DTS'ed a copy of A as B, so I at least
have that much saved. Can I just change the definition on my id field
on table A back to identity = yes and re-save, or is it going to be much
worse than that to repair?



Jim



Jim Nueske

Pacific Seafood




MS Sql Server LazyDBA home page