when will my database corrupt (int type and use identity)
Database
2
Posts
2
Posters
0
Views
1
Watching
-
I choose my table key is int type and use identity. I don't know HOw many record it have to corrupt my database? Please help me. If that not good please tell me a better way. Thanks
I don't know what you mean by "when will my database corrupt"? Do you mean how many rows can you insert before the key has to wrap around? If you are using an int type you have a maximum of 4294967296 unique values. ColinMackay.net "Man who stand on hill with mouth open will wait long time for roast duck to drop in." -- Confucius "If a man empties his purse into his head, no man can take it away from him, for an investment in knowledge pays the best interest." -- Joseph E. O'Donnell