What are the challenges you face when working across database platforms? Take the survey

Query Analyzer Warning Question

Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
edited December 11, 2003 7:54AM in SQL Compare Previous Versions
Hi John,

I know what causes this warning! It's a shortcoming with SQL server.
Since it only has a 'page size' of 8060, it can only return that many bytes
in a row of data. You could potentially build a table with 50 columns of
varchar(256) without encountering an error, which is why you got let off
with a warning which doesn't cause the script to fail. What it's trying to
tell you is that if you do an INSERT query on this table sometime in the
future filling all 50 columns with 256 characters of data, the query will
probably fail.


Brian Donahue
Red Gate Technical Support

"John Seelig" <jseelig@compasslearning.com> wrote in message
> Can anyone explain why I get errors like this when synchronizing my
> Both DB's are SQL2K SP3.
> Warning: The table 'TABLEX' has been created but its maximum row size
> (144059) 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
> 8060 bytes.
> Thanks in advance,
> jseelig@compasslearning.com
This discussion has been closed.