maximum number of bytes per row (8060)

• MBHblows

  SSCommitted

  Points: 1614

  More actions

  August 18, 2005 at 1:17 pm

  #363469

  Hello,

  I'm Moveing a bunch of rows that I scripted out from a Production Database to Test and I am getting the following errors.

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

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

  How will this effect selects and manipulation and even replication on these Tables? Will it Truncate data that exceeds 8060 bytes? Does it mean that the data in these rows actually exceeds 8060 bytes or that my datatypes simply allow them to do so?

   

  J

• Ninja's_RGR'us

  SSC Guru

  Points: 294069

  More actions

  August 18, 2005 at 1:23 pm

  #583278

  Quadruple post, finish the thread here :

  http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=8&messageid=211788