Row Size Problem 1

[tapks]

Hi!

I am facing the following problem while creating a table. The warning message is as follows:

" Warning: The table 'sh_producto' has been created but its maximum row size (14232) exceeds the maximum number of bytes per row (8060). INSERT or UPDATE of a row in this table will fail if the resulting row length exceeds 8060 bytes."

How can I increase the row size? Is there any way?

Pl help me.

Thankx in advance.

Tapks

 

[fluteplr]

No.

You are either going to have to split this into two tables or reduce the size of some of your fields.

I would guess you have some large varchar or nvarchar fields defined in the table, yo might want to look at those and see if they should be defined as text fields instead. (Text fields only take up 16 bytes of the tables rowsize)