Developer forum

How many custom fields have you created? My guess is too many.

What version of SQL Server are you running?

If you indeed have too many fields, but you need them all, try changing fields like Text(100) and Text(255) to LongText. This will give you a text area instead, but the field changes from an nvarchar(100/255) to an nvarchar(max) whose value doesn't add up to the maximum record size (and than the length of the field itself which is 16 if I am not mistaken).

Hope this helps,

Imar

Well it's 46 custom fields, most of the are nvarchar(20/50), ints and floats. I did try to clean most of the fields and save but it did not help.

Thanx Imar. Thats a good tip to keep in mind if you know that you will be dealing with  lot of custom fields. 

/Aki

It was actually not the products table that was the problem.

We checked with SQL profiler and the error occurs when the OrderLines table is updated with productname. We don't know why this happends yet, the row does not seem to be too large.

/Aki