Monday, 10 December 2007

Table limit

Table in Navision can support up to:
1) 8KB of data per row- this is due to SQL Server table limit to 8KB of data per row.
2) 500 fields
3) 40 keys.


Steven said...

I think you made a typo.
The limit is 8k per row, not per table.

See also:

Admin said...

Thanks Steven,

I have corrected the error.

Admin said...

What about the BLOB?
"The maximum size of a BLOB is normally determined by your system's disk storage capacity. However, the maximum size in C/SIDE is 2GB"

Unknown said...

I think that the limit is 4000 bytes per row - due to compatibility with native DB...