Table Row Length

  • I just need something clarified.

    We received some scripts from a vendor for the SQL Server database for their app.  In their script, one of the tables they create has a maximum row length greater than 8060 (8442 to be exact).  When the table is created, a warning message appears that if you try to insert or update a record that is longer than 8060 bytes, the action will fail.

    Does this mean that the table can be created this big but you just can't insert data larger than the maximum.

    I understand about the limit and pages, etc.  I also think there is probably another way to build this table so we don't even have this issue.  But, since it is a third-party app, there is not much I can do.

    I just want to make sure I understand what is going on.

    Thanks,

    hawg

    ----------------------------------------------------------01010011010100010100110000100000010100110110010101110010011101100110010101110010001000000101001001101111011000110110101101110011

  • Can you tell me how to translate that signature?

  • Table will be created. The inserts will fail with error if the limit is met.

  • Convert my signature by using this website:

    http://www.theskull.com/javascript/ascii-binary.html

    ----------------------------------------------------------01010011010100010100110000100000010100110110010101110010011101100110010101110010001000000101001001101111011000110110101101110011

  • Doesn't work....

  • Site works only in IE. And ya they Rock .

  • Sorry, didn't realize it only works in IE.  I was just having a little fun.

    There are a million conversion sites on the web, I figure it could be converted in many of these sites.  The link I sent is just the one I found first when I created it.

    ----------------------------------------------------------01010011010100010100110000100000010100110110010101110010011101100110010101110010001000000101001001101111011000110110101101110011

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply