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.

4 comments:

Steven said...

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

See also:
http://msdn.microsoft.com/en-us/library/ms186981.aspx

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...

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