I had a problem similar to this recently, and the issue turned out to be that the autogrowth setting was set to 5000% rather than 5000M. I believe that...

I use identity keys on virtually every table for the same reasons mentioned:

1. Natural keys have a way of proving themselves non-unique as time goes on

2. Relational integrity...