Board index MS SQL Server

**exceeds the maximum number of bytes per row

**exceeds the maximum number of bytes per row

Post by R-M » Fri, 02 Jan 2004 11:52:04



Hi

I've a table with 4000 records and following structure,
and sometime I've got an error like below why?

CREATE TABLE [ENPARTT] (
        [ENPART_COD] [char] (6) COLLATE SQL_Latin1_General_CP1256_CI_AS NOT NULL ,
        [ENPART_NAME] [char] (30) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
        [ENPART_SPEC] [char] (20) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
        [ENPART_ASEM] [char] (1) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
        [ENPART_DEACTIVE] [char] (1) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL
,
        [ENPART_MODEL] [char] (20) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
        [ENPART_RETURN] [char] (1) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
        [STSHP_COD] [char] (2) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
        [STSTCK_COD] [char] (1) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
        [ENPART_PNAME] [char] (30) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
        [STTPRD_COD] [char] (2) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
        [ENPART_NCOD] [char] (8) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
        [ENPART_MAP] [char] (25) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
        [ENPART_TEC] [char] (30) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
        [ENPART_KIND] [char] (1) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
        [ENPART_VOL] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
        [ENPART_DIA] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
        [ENPART_HEIGHT] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
        [ENPART_WIDTH] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
        [ENPART_LENGTH] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
        [ENPART_DENS] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
        [ENPART_SPMASS] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
        [ENPART_VISCO] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
        [ENPART_FLAM] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
        [ENPART_PH] [char] (1) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
        [ENPART_HARD] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
        [ENPART_TENSION] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL
,
        [ENPART_JERK] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
        [ENPART_STROKE] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
        [ENPART_INTORSION] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS
NULL ,
        [ENPART_BOND] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
        [ENPART_VOLT] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
        [ENPART_POWER] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
        [ENPART_AMPERE] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
        [ENPART_PHASE] [char] (1) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
        [ENPART_CYCLE] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
        [ENPART_STRING] [char] (2) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
        [ENPART_IDCODE] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
        [ENPART_BUSHDEG] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL
,
        [ENPART_FREQ] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
        [ENPART_THECONS] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL
,
        [ENPART_STCONS] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
        [ENPART_AVCONS] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
        [ENPART_PKCOD] [char] (1) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
        [ENPART_PKAMNT] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
        [ENPART_PKDIM] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
        [ENPART_PKMASS] [varchar] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS
NULL ,
        [ENPART_ENDESC] [varchar] (2000) COLLATE SQL_Latin1_General_CP1256_CI_AS
NULL ,
        [ENPART_TEMP] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
        [ENPART_DAMP] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
        [ENPART_LIGHT] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
        [ENPART_ARRANG] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
        [ENPART_CONSTIME] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL
,
        [ENPART_CONSERV] [varchar] (2000) COLLATE SQL_Latin1_General_CP1256_CI_AS
NULL ,
        [ENPART_DIMEXAM] [varchar] (2000) COLLATE SQL_Latin1_General_CP1256_CI_AS
NULL ,
        [ENPART_OUTEXAM] [varchar] (2000) COLLATE SQL_Latin1_General_CP1256_CI_AS
NULL ,
        [ENPART_ELECEXAM] [varchar] (2000) COLLATE SQL_Latin1_General_CP1256_CI_AS
NULL ,
        [ENPART_MECEXAM] [varchar] (2000) COLLATE SQL_Latin1_General_CP1256_CI_AS
NULL ,
        [ENPART_PHYSEXAM] [varchar] (2000) COLLATE SQL_Latin1_General_CP1256_CI_AS
NULL ,
        [ENPART_CHEMEXAM] [varchar] (2000) COLLATE SQL_Latin1_General_CP1256_CI_AS
NULL ,
        [ENPART_THEMEXAM] [varchar] (2000) COLLATE SQL_Latin1_General_CP1256_CI_AS
NULL ,
        [ENPART_ASEMEXAM] [varchar] (2000) COLLATE SQL_Latin1_General_CP1256_CI_AS
NULL ,
        [ENPART_USAGEXAM] [varchar] (2000) COLLATE SQL_Latin1_General_CP1256_CI_AS
NULL ,
        [ENPART_FINEXAM] [varchar] (2000) COLLATE SQL_Latin1_General_CP1256_CI_AS
NULL ,
        [ENPART_SAMPLING] [varchar] (300) COLLATE SQL_Latin1_General_CP1256_CI_AS
NULL ,
        [ENPART_LOC] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
        [ENPART_MINSTOCK] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL
,
        [ENPART_MAXSTOCK] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL
,
        [ENPART_ORDERLIM] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL
,
        [ENPART_ORDERAMNT] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS
NULL ,
        [ENPART_PROGTIM] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL
,
        [ENPART_PLDESC] [varchar] (1500) COLLATE SQL_Latin1_General_CP1256_CI_AS
NULL ,
        [ENPART_SOURCE] [char] (1) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
        [ENPART_SUPLOC] [char] (1) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
        [ENPART_MINREQ] [char] (15) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
        [ENPART_REQTIME] [char] (15) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL
,
        [ENPART_SUGPK] [char] (100) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
        [ENPART_PROVTYP] [char] (1) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
        [ENPART_SUDESC] [varchar] (1500) COLLATE SQL_Latin1_General_CP1256_CI_AS
NULL ,
        [ENPART_MASS] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
        CONSTRAINT [PK__ENPARTT] PRIMARY KEY  CLUSTERED         (
                [ENPART_COD]
        )  ON [PRIMARY] ,
        CONSTRAINT [FK_ENPARTT_STSHPT] FOREIGN KEY      (
                [STSHP_COD]
        ) REFERENCES [STSHPT] (
                [STSHP_COD]
        ),
        CONSTRAINT [FK_ENPARTT_STSTCKT] FOREIGN KEY     (
                [STSTCK_COD]
        ) REFERENCES [STSTCKT] (
                [STSTCK_COD]
        ),
        CONSTRAINT [FK_ENPARTT_STTPRDT] FOREIGN KEY     (
                [STTPRD_COD]
        ) REFERENCES [STTPRDT] (
                [STTPRD_COD]
        )
) ON [PRIMARY]
GO

---------------------------------
Warning: The table 'ENPARTT' has been created but its maximum row size
(28078) 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.
--

Thanks for any guide
Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/

 
 
 
Top

**exceeds the maximum number of bytes per row

Post by oj » Fri, 02 Jan 2004 12:36:41


This is by design. You cannot have more than 8kb per row.

http://msdn.microsoft.com/library/en-us/architec/8_ar_ts_8dbn.asp?fra...

--
-oj
http://www.rac4sql.net


Quote:> Hi

> I've a table with 4000 records and following structure,
> and sometime I've got an error like below why?

> CREATE TABLE [ENPARTT] (
> [ENPART_COD] [char] (6) COLLATE SQL_Latin1_General_CP1256_CI_AS NOT NULL ,
> [ENPART_NAME] [char] (30) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_SPEC] [char] (20) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_ASEM] [char] (1) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_DEACTIVE] [char] (1) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL
> ,
> [ENPART_MODEL] [char] (20) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_RETURN] [char] (1) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [STSHP_COD] [char] (2) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [STSTCK_COD] [char] (1) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_PNAME] [char] (30) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [STTPRD_COD] [char] (2) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_NCOD] [char] (8) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_MAP] [char] (25) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_TEC] [char] (30) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_KIND] [char] (1) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_VOL] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_DIA] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_HEIGHT] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_WIDTH] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_LENGTH] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_DENS] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_SPMASS] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_VISCO] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_FLAM] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_PH] [char] (1) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_HARD] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_TENSION] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL
> ,
> [ENPART_JERK] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_STROKE] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_INTORSION] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS
> NULL ,
> [ENPART_BOND] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_VOLT] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_POWER] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_AMPERE] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_PHASE] [char] (1) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_CYCLE] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_STRING] [char] (2) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_IDCODE] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_BUSHDEG] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL
> ,
> [ENPART_FREQ] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_THECONS] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL
> ,
> [ENPART_STCONS] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_AVCONS] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_PKCOD] [char] (1) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_PKAMNT] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_PKDIM] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_PKMASS] [varchar] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS
> NULL ,
> [ENPART_ENDESC] [varchar] (2000) COLLATE SQL_Latin1_General_CP1256_CI_AS
> NULL ,
> [ENPART_TEMP] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_DAMP] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_LIGHT] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_ARRANG] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_CONSTIME] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL
> ,
> [ENPART_CONSERV] [varchar] (2000) COLLATE SQL_Latin1_General_CP1256_CI_AS
> NULL ,
> [ENPART_DIMEXAM] [varchar] (2000) COLLATE SQL_Latin1_General_CP1256_CI_AS
> NULL ,
> [ENPART_OUTEXAM] [varchar] (2000) COLLATE SQL_Latin1_General_CP1256_CI_AS
> NULL ,
> [ENPART_ELECEXAM] [varchar] (2000) COLLATE SQL_Latin1_General_CP1256_CI_AS
> NULL ,
> [ENPART_MECEXAM] [varchar] (2000) COLLATE SQL_Latin1_General_CP1256_CI_AS
> NULL ,
> [ENPART_PHYSEXAM] [varchar] (2000) COLLATE SQL_Latin1_General_CP1256_CI_AS
> NULL ,
> [ENPART_CHEMEXAM] [varchar] (2000) COLLATE SQL_Latin1_General_CP1256_CI_AS
> NULL ,
> [ENPART_THEMEXAM] [varchar] (2000) COLLATE SQL_Latin1_General_CP1256_CI_AS
> NULL ,
> [ENPART_ASEMEXAM] [varchar] (2000) COLLATE SQL_Latin1_General_CP1256_CI_AS
> NULL ,
> [ENPART_USAGEXAM] [varchar] (2000) COLLATE SQL_Latin1_General_CP1256_CI_AS
> NULL ,
> [ENPART_FINEXAM] [varchar] (2000) COLLATE SQL_Latin1_General_CP1256_CI_AS
> NULL ,
> [ENPART_SAMPLING] [varchar] (300) COLLATE SQL_Latin1_General_CP1256_CI_AS
> NULL ,
> [ENPART_LOC] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_MINSTOCK] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL
> ,
> [ENPART_MAXSTOCK] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL
> ,
> [ENPART_ORDERLIM] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL
> ,
> [ENPART_ORDERAMNT] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS
> NULL ,
> [ENPART_PROGTIM] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL
> ,
> [ENPART_PLDESC] [varchar] (1500) COLLATE SQL_Latin1_General_CP1256_CI_AS
> NULL ,
> [ENPART_SOURCE] [char] (1) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_SUPLOC] [char] (1) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_MINREQ] [char] (15) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_REQTIME] [char] (15) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL
> ,
> [ENPART_SUGPK] [char] (100) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_PROVTYP] [char] (1) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_SUDESC] [varchar] (1500) COLLATE SQL_Latin1_General_CP1256_CI_AS
> NULL ,
> [ENPART_MASS] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> CONSTRAINT [PK__ENPARTT] PRIMARY KEY  CLUSTERED (
> [ENPART_COD]
> )  ON [PRIMARY] ,
> CONSTRAINT [FK_ENPARTT_STSHPT] FOREIGN KEY (
> [STSHP_COD]
> ) REFERENCES [STSHPT] (
> [STSHP_COD]
> ),
> CONSTRAINT [FK_ENPARTT_STSTCKT] FOREIGN KEY (
> [STSTCK_COD]
> ) REFERENCES [STSTCKT] (
> [STSTCK_COD]
> ),
> CONSTRAINT [FK_ENPARTT_STTPRDT] FOREIGN KEY (
> [STTPRD_COD]
> ) REFERENCES [STTPRDT] (
> [STTPRD_COD]
> )
> ) ON [PRIMARY]
> GO

> ---------------------------------
> Warning: The table 'ENPARTT' has been created but its maximum row size
> (28078) 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.
> --

> Thanks for any guide
> Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/


 
 
 
Top

**exceeds the maximum number of bytes per row

Post by R Rupasingh » Fri, 02 Jan 2004 12:48:29


Hi R-M,

The reason for the warning is that maximum size of a row on your table
exeecds 8kb.
This restriction is by design.
SQL Server stores it's data on 8kb pages & a single row must fit in a single
page.
ie. it cannot span to multiple pages.

Try to normalize the table to reduce no of fields on your table.

Hope above will help you!

Ranil.


Quote:> Hi

> I've a table with 4000 records and following structure,
> and sometime I've got an error like below why?

> CREATE TABLE [ENPARTT] (
> [ENPART_COD] [char] (6) COLLATE SQL_Latin1_General_CP1256_CI_AS NOT NULL ,
> [ENPART_NAME] [char] (30) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_SPEC] [char] (20) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_ASEM] [char] (1) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_DEACTIVE] [char] (1) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL
> ,
> [ENPART_MODEL] [char] (20) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_RETURN] [char] (1) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [STSHP_COD] [char] (2) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [STSTCK_COD] [char] (1) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_PNAME] [char] (30) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [STTPRD_COD] [char] (2) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_NCOD] [char] (8) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_MAP] [char] (25) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_TEC] [char] (30) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_KIND] [char] (1) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_VOL] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_DIA] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_HEIGHT] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_WIDTH] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_LENGTH] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_DENS] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_SPMASS] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_VISCO] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_FLAM] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_PH] [char] (1) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_HARD] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_TENSION] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL
> ,
> [ENPART_JERK] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_STROKE] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_INTORSION] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS
> NULL ,
> [ENPART_BOND] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_VOLT] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_POWER] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_AMPERE] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_PHASE] [char] (1) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_CYCLE] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_STRING] [char] (2) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_IDCODE] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_BUSHDEG] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL
> ,
> [ENPART_FREQ] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_THECONS] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL
> ,
> [ENPART_STCONS] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_AVCONS] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_PKCOD] [char] (1) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_PKAMNT] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_PKDIM] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_PKMASS] [varchar] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS
> NULL ,
> [ENPART_ENDESC] [varchar] (2000) COLLATE SQL_Latin1_General_CP1256_CI_AS
> NULL ,
> [ENPART_TEMP] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_DAMP] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_LIGHT] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_ARRANG] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_CONSTIME] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL
> ,
> [ENPART_CONSERV] [varchar] (2000) COLLATE SQL_Latin1_General_CP1256_CI_AS
> NULL ,
> [ENPART_DIMEXAM] [varchar] (2000) COLLATE SQL_Latin1_General_CP1256_CI_AS
> NULL ,
> [ENPART_OUTEXAM] [varchar] (2000) COLLATE SQL_Latin1_General_CP1256_CI_AS
> NULL ,
> [ENPART_ELECEXAM] [varchar] (2000) COLLATE SQL_Latin1_General_CP1256_CI_AS
> NULL ,
> [ENPART_MECEXAM] [varchar] (2000) COLLATE SQL_Latin1_General_CP1256_CI_AS
> NULL ,
> [ENPART_PHYSEXAM] [varchar] (2000) COLLATE SQL_Latin1_General_CP1256_CI_AS
> NULL ,
> [ENPART_CHEMEXAM] [varchar] (2000) COLLATE SQL_Latin1_General_CP1256_CI_AS
> NULL ,
> [ENPART_THEMEXAM] [varchar] (2000) COLLATE SQL_Latin1_General_CP1256_CI_AS
> NULL ,
> [ENPART_ASEMEXAM] [varchar] (2000) COLLATE SQL_Latin1_General_CP1256_CI_AS
> NULL ,
> [ENPART_USAGEXAM] [varchar] (2000) COLLATE SQL_Latin1_General_CP1256_CI_AS
> NULL ,
> [ENPART_FINEXAM] [varchar] (2000) COLLATE SQL_Latin1_General_CP1256_CI_AS
> NULL ,
> [ENPART_SAMPLING] [varchar] (300) COLLATE SQL_Latin1_General_CP1256_CI_AS
> NULL ,
> [ENPART_LOC] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_MINSTOCK] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL
> ,
> [ENPART_MAXSTOCK] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL
> ,
> [ENPART_ORDERLIM] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL
> ,
> [ENPART_ORDERAMNT] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS
> NULL ,
> [ENPART_PROGTIM] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL
> ,
> [ENPART_PLDESC] [varchar] (1500) COLLATE SQL_Latin1_General_CP1256_CI_AS
> NULL ,
> [ENPART_SOURCE] [char] (1) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_SUPLOC] [char] (1) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_MINREQ] [char] (15) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_REQTIME] [char] (15) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL
> ,
> [ENPART_SUGPK] [char] (100) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_PROVTYP] [char] (1) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> [ENPART_SUDESC] [varchar] (1500) COLLATE SQL_Latin1_General_CP1256_CI_AS
> NULL ,
> [ENPART_MASS] [char] (10) COLLATE SQL_Latin1_General_CP1256_CI_AS NULL ,
> CONSTRAINT [PK__ENPARTT] PRIMARY KEY  CLUSTERED (
> [ENPART_COD]
> )  ON [PRIMARY] ,
> CONSTRAINT [FK_ENPARTT_STSHPT] FOREIGN KEY (
> [STSHP_COD]
> ) REFERENCES [STSHPT] (
> [STSHP_COD]
> ),
> CONSTRAINT [FK_ENPARTT_STSTCKT] FOREIGN KEY (
> [STSTCK_COD]
> ) REFERENCES [STSTCKT] (
> [STSTCK_COD]
> ),
> CONSTRAINT [FK_ENPARTT_STTPRDT] FOREIGN KEY (
> [STTPRD_COD]
> ) REFERENCES [STTPRDT] (
> [STTPRD_COD]
> )
> ) ON [PRIMARY]
> GO

> ---------------------------------
> Warning: The table 'ENPARTT' has been created but its maximum row size
> (28078) 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.
> --

> Thanks for any guide
> Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/

 
 
 
Top

**exceeds the maximum number of bytes per row

Post by R-M » Fri, 02 Jan 2004 13:04:23


If we don't modify the structure what will be happen?
will the information be lost at the insertion?


> This is by design. You cannot have more than 8kb per row.

> http://msdn.microsoft.com/library/en-
> us/architec/8_ar_ts_8dbn.asp?frame=true

--
Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/
 
 
 
Top

**exceeds the maximum number of bytes per row

Post by Kalen Delane » Fri, 02 Jan 2004 18:51:05


Any row that you insert that has more than the maximum bytes will generate
an error on insertion. Other data, that doesn't use so much of all your
varchar fields, can be successfully inserted.

--
HTH
----------------
Kalen Delaney
SQL Server MVP
www.SolidQualityLearning.com


> If we don't modify the structure what will be happen?
> will the information be lost at the insertion?


> > This is by design. You cannot have more than 8kb per row.

> > http://msdn.microsoft.com/library/en-
> > us/architec/8_ar_ts_8dbn.asp?frame=true

> --
> Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/

 
 
 
Top

1. Exceed the maximum number of bytes per row.

Dears

  I'm using MS SQL 6.5 with Service Pack 4.

   For getting data at just one HTML page, I created many columns on the
table "mjl_applicant". When I create constraint, I got the following message
saying  "The total row size, 2144, for table 'mjl_applicant' exceeds the
maximum number of bytes per row, 1962."

  Even it shows warning, there is no problem in inserting & querying data.
Might there be some problems in the future?

Thanks in Advance

2. Program getting slower with time use

3. Exceeding maximum number of bytes per row

4. REMINDER: The Computer Science Bibliography Collection

5. maximum row size (17075) exceeds the maximum number of bytes per row (8060).

6. server alias for "dot" in client network utility

7. maximum number of bytes per row!!!

8. ODBC Workshop at DB/Expo NY (Dec. 6)

9. error from maximum number of bytes per row

10. maximum number of bytes per row, 1962.

11. Maximum number of bytes per row

12. maximum number of bytes per row


All times are UTC
Board index