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.

Regards,

Brian Donahue
Red Gate Technical Support

"John Seelig" <jseelig@compasslearning.com> wrote in message
news:lO%23ZDPdvDHA.304@server53...
> Can anyone explain why I get errors like this when synchronizing my
schema?
> 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
exceeds
> 8060 bytes.
>
> Thanks in advance,
>
> jseelig@compasslearning.com
>
>
This discussion has been closed.