Row sizes exceeding 8060 bytes in Sql 2005

re: Row sizes exceeding 8060 bytes in Sql 2005

chrisleonard — Sat, 24 Feb 2007 21:55:36 GMT

Is this a new feature of SP2? I generated the following error message on SQL 2005 back in May 2006 (for a post I made on SqlServerCentral). However, I don't know what release that was on.

create table dbo.t1 (x char(60) not null, y char(8000) not null)

Msg 1701, Level 16, State 1, Server MINOTAUR, Line 1

Creating or altering table 't1' failed because the minimum row size would be 8067, including 7 bytes of internal overhead. This exceeds the maximum allowable table row size of 8060 bytes.

Thanks,

Chris

re: Row sizes exceeding 8060 bytes in Sql 2005

boydc7 — Sun, 25 Feb 2007 22:12:36 GMT

Hi Chris. You are seeing this error because you are trying to create a table that has a row with FIXED data columns in excess of 8060 bytes...notice in my post that it mentions there is still a limit on FIXED data size for a single row of 8060 bytes...the Row-overflow data and rows in excess of 8060 bytes is only possible using VARIABLE data types...if you change your table syntax to the following, you'll notice it should work without issue:

create table dbo.t1 (x char(60) not null, y varchar(8000) not null)

HTH

re: Row sizes exceeding 8060 bytes in Sql 2005

chrisleonard — Mon, 26 Feb 2007 07:24:14 GMT

Well, d'oh! Yeah, that makes sense. Thanks for taking the time to point this out.

Cheers,

Chris