Table Size more then 4000 bytes

vijay_g

hi experts,
in nav 4.0 sp3 ,any solution to make a table more then 4000 bytes size becoz when we accross this size then it does show error like "the active field in a record may not take up more then 4000 bytes"


Thanx in advance




Vijay Kumar Gupta

kriki

You can disable or shorten some fields.

Or you can use a second table in which to put some fields.

For the moment, there are no other ways.

matteo_montanari

vijay_g wrote:

hi experts,
in nav 4.0 sp3 ,any solution to make a table more then 4000 bytes size becoz when we accross this size then it does show error like "the active field in a record may not take up more then 4000 bytes"


Thanx in advance

Vijay Kumar Gupta

Hi

Are you on SQL Server or a Navision Database?

If you use SQL, you can change on table "$ndo$dbproperty" Field "maxrecsize" to 8060 (maximum SQL record size).
But doing this, you can't restore your database to a Navision Database because you will break the compatibility.

Bye

Matteo

David_Singleton

Seriously think why you need more than 4000 bytes and rethink your design. If the table is this big then its probably a bad design.