October 8, 2003 at 5:16 am
Hi experts,
Sql server 2000 with Win2k
I am getting warning out of a sp
Warning: The table '#DetailXML' has been created but its maximum row size (40242) 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.
I dont have any problem with this waring since my table is of read only type but I want to supress this warning message since any message out from sp kills my report server when this sp is called from a web reporing tool.
October 14, 2003 at 5:00 am
40k? Wow.
I don't know of a way to suppress it. Would fixing it be that difficult?
Andy
October 14, 2003 at 7:08 am
Actually i am storing xmls of 8k each in many of the fields of table , it is a read only table so no threat of INSERT/UPDATE and size increases.But this warning cause my report which is calling this sp is killing.
October 14, 2003 at 8:32 am
Are all agreeing that there is no structured exception handling in SQL?
October 14, 2003 at 10:05 am
That's correct, no SEH - you have to check @@Error to see if something went wrong.
Why wouldnt you change the columns to type = text, avoiding the warning and using the 'right' data type at the same time?
Andy
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply