sql server - I am getting this error: Cannot create a row of size 8785 which is greater than the allowable maximum of 8060 -

in of cases due overall row size particular record throw such error. case different. run report in 1 server , works fine. same report , same database throw row size error: cannot create row of size 8785 greater allowable maximum of 8060. suggestions how can resolve this?

from http://blogs.msdn.com/b/msdnts/archive/2006/12/01/row-size-limitation-in-sql-2000-and-2005.aspx:

when creating table, may encounter following information: ' table has been created maximum row size(11038) exceeds maximum number of bytes per row (8060). insert or update of row in table fail if resulting row length exceeds 8060 bytes.

something in report second time around hitting maximum; possibly edge case haven't spotted, there is difference in data.

i'd suggest @ allocations given database fields - example, can varchar(8000) switched varchar(max) - or @ restructuring data across multiple tables.