>For some documentation, I need to calculate the number of records that a given table would need to have in order to hit the 2G file size limit.
>
>My formula so far is
>
>nSizeOfEmptyTable + 2*(2^30)/nRowWidth
>
>Is there anything I'm missing, doing wrong, etc?
>
>TIA
Shouldn't that be:
((2**31) - nSizeOfEmptyTable) / nRowWidth
Don't forget that a row consists of one extra character for the DELETED status.