August 18, 2005 at 1:17 pm
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
August 18, 2005 at 1:26 pm
It means that the datatypes allow that to happen. It throws an error when you try to insert data that is too long :
create table #test (a varchar(8000), b varchar(8000))
insert into #test (a, b) values (replicate('A', 8000), replicate('B', 8000))
drop table #test
August 18, 2005 at 2:00 pm
Thank you, Sorry that was posted 3 times.
j
August 18, 2005 at 2:04 pm
I know... redirected all other posts to this one.
Actully was posted 4 times... next time give the server a chance if he's slow... even if giving an error message, the sps usually finish their work anyways (web server's failing not sql).
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply