Saturday, September 27, 2014

error reducing the length of a nvarchar(4000) column

The maximum allowable table row size is 8060 bytes. Dose the table has other columns which lead to this overflow?


Please have a look at this sample:



create table Test
(id int not null,
char1 char(8000) not null,
char2 char(8000) not null)



more info:


Row sizes exceeding 8060 bytes in Sql 2005




Saeid Hasani [sqldevelop]



No comments:

Post a Comment